Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection worksheet
use this code. ActiveSheet.Unprotect Password:="pass123" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection worksheet
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? "Heera" wrote: use this code. ActiveSheet.Unprotect Password:="pass123" |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection worksheet
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet protection | Excel Worksheet Functions | |||
Worksheet Protection | Excel Worksheet Functions | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Worksheet Protection | Excel Programming |