I have an ots Template spreadsheet. I’d like to force each user that creates a new file from this template to fill in some specific cell(s), before he can save the file.
Is this possible, and how? Bonus points if it works in Excel, too.
It isn’t difficult to do with a macro. But it should be allowed to use macros in the office. (I am opposed to any restriction of freedom of user interaction)
Hi
As @JohnSUN says, except by macro I see no solution (and I don’t like restrictions too…) and if the user does not allow macro execution procedure is useless.
So, I do not know if this may apply to your case, but an “approximated” workaround could be the opposite: pre-fill the cell with a text that the user should replace.
In the Fill.ots example, B3 displays Fill with your name, and the cell remains red if empty or equal to “Fill with your name.” (Format▸Conditional Formatting▸Condition)
It is not absolute safety, but may be it is enough incentive…
Regards