Thread: Protection
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul Paul is offline
external usenet poster
 
Posts: 16
Default Protection

I have a budget sheet which allows restricted access (users without
password can only update certain cells).

I want to be able to lock the sheet/unlock the sheet using buttons. I
have tried a Macro but after the first time it only protects the sheet
without a password.

Can any one tell me how to correct this without having to go to Tools,
Protection, etc etc every time as users might forget to do this.

Thanks