Protection worksheet

  • Thread starter Thread starter Hamed parhizkar
  • Start date Start date
H

Hamed parhizkar

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?
 
Where would I put that, under the script for the command button? If so, I did
then when I protected the sheet I still got a debug error 1004. Do you have
an email address so you can look at it?
 
Back
Top