Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect sheets allow buttons
How do I protect a worksheet but allow a control button to work?
Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect sheets allow buttons
You may want to allow the code to unlock the worksheet...
Function ThePassword() ThePassword = "Excel_1" End Function Sub Add_Member() Dim mName As String ActiveWorkbook.Unprotect (ThePassword()) Worksheets("Template").Unprotect (ThePassword()) ''' Ask for new name mName = InputBox("Enter new member's name.") Sheets("Template").Copy After:=Sheets(Sheets.Count) <do other stuff Worksheets("Menu").Select Worksheets("Template").Protect (ThePassword()) ActiveWorkbook.Protect Exit Sub "pywhacket" wrote: How do I protect a worksheet but allow a control button to work? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect sheets in one go | Excel Discussion (Misc queries) | |||
Protect some sheets in an xls but not all. | Excel Worksheet Functions | |||
how to protect excel worksheet and still use the outline buttons? | Excel Worksheet Functions | |||
how to protect sheets from VBA? | Excel Programming | |||
Protect sorting buttons in menubar | Excel Programming |