View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shilps Shilps is offline
external usenet poster
 
Posts: 36
Default Protecting worksheet

Hi
I have a worksheet that is used to display the data by selecting various options in the different controls. I want that no user is able to change anything except select different options. I first unlocked various objects and cells and password protected it( I do not want the code to be visible) but the problem is that even by first unlocking different cells and objects , the code is giving run-time error
Is there any solution to it
TI
Shilps