"Remove protection" dialogue box shown while opening excel file

  • Thread starter Thread starter Per Johansson
  • Start date Start date
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?
 
In Excel 2002 and later, the UserInterfaceOnly setting requires you to
provide the password. In earlier versions it didn't. Just a guess, but
perhaps this is the source of the problem.
 
In Excel 2002 and later, the UserInterfaceOnly setting requires you to
provide the password. In earlier versions it didn't. Just a guess, but
perhaps this is the source of the problem.
Click to expand...

Thank you.
I added the password parameter to the macros and sent the file to the
user, so I hope there are no other pitfalls. There's a document about
programming "What's new in Excel 2002" but I can't find anything about
what's changed, other than the UserInterfaceOnly setting.
 
Back
Top