View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default Sheet protection complications

My workbook contains multiple sheets. After a set time
period, the workbook will automatically run code that
will password protect each and EVERY sheet in the workbook.

My question is, what happens if a user decides to password
protect a sheet with his/her own password before my code
automatically tries to do the script above?? It will try to
password protect a sheet that has already been password
protected by the user, therefore it will fail right?? If this is
true, can I prevent users from password protecting their sheets
with their own passwords???

thank u