Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden cells
I have macro that makes some cells hidden when pressing a button. I also want
to protect parts of the worksheet so that users cannot change info in selected cells. However there seems to be a problem with the macro and protecting the worksheet, the macro violates the protection. Is there any way to solve this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden cells
Hi Freddie,
Try something like: '============= Public Sub Tester() ActiveSheet.Unprotect Password:="YourPassword" 'Your code ActiveSheet.Protect Password:="YourPassword" End Sub '<<============= --- Regards, Norman "Freddie Mac" wrote in message ... I have macro that makes some cells hidden when pressing a button. I also want to protect parts of the worksheet so that users cannot change info in selected cells. However there seems to be a problem with the macro and protecting the worksheet, the macro violates the protection. Is there any way to solve this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Visible Cells in Sheet with Merged and Hidden Cells | Excel Discussion (Misc queries) | |||
drag data vertically over hidden cells.. ignore hidden cells | Excel Discussion (Misc queries) | |||
How do I paste hidden cells and keep them hidden? | Excel Discussion (Misc queries) | |||
Hidden cells | Excel Programming | |||
Hidden cells ????? | Excel Worksheet Functions |