P
Per Johansson
I made an Excel file with some macros that write to locked cells in a
protected sheet, using UserInterfaceOnly at the top of every macro to
bypass the protection. One macro, setting default values, is run on
opening the Worksheet.
Now the user says that the dialogue box "Remove sheet protection" is
always shown when he opens the file. That doesn't happen here. What
could be the cause of that behaviour?
protected sheet, using UserInterfaceOnly at the top of every macro to
bypass the protection. One macro, setting default values, is run on
opening the Worksheet.
Now the user says that the dialogue box "Remove sheet protection" is
always shown when he opens the file. That doesn't happen here. What
could be the cause of that behaviour?