| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
I have created a button to hide and unhide certain cells in a worksheet
however when i protect the worksheet my macros stop working and basically wont let me use my buttons-the hidden parts become highlighted aswel. I am also making it so only specific people can only edit specific parts of the sheet and due to my macros messing things up they are not working. i really don't know what to do any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macros
Unprotect the worksheet in the macro, like so:
Sub MyMacro() Activesheet.unprotect password:="mypassword" 'your code here Activesheet.protect password:="mypassword" End Sub HTH, James "chris123" wrote in message ... I have created a button to hide and unhide certain cells in a worksheet however when i protect the worksheet my macros stop working and basically wont let me use my buttons-the hidden parts become highlighted aswel. I am also making it so only specific people can only edit specific parts of the sheet and due to my macros messing things up they are not working. i really don't know what to do any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros in Personal.xls that would create two toolbars and buttonswith assigned macros | Excel Programming | |||
| choose default macros Not Enabled / Macros Enable Setting | Excel Programming | |||
| weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
| convert lotus 123w macros to excel macros | Excel Programming | |||
| Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
Linear Mode
