View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hamed parhizkar Hamed parhizkar is offline
external usenet poster
 
Posts: 45
Default Protection worksheet

I grouped several lines together, such as line 100-150, so I can click on the
+ and - to unhide then hide the cells. I also created a command button that
unhides the lines and hides them. Everything works perfect but when I try to
protect the sheet so the formulas dont get messed up.... if you click the
button I keep getting a debug error 1004. Is there no way to protect a sheet
and still have a functional command button?