Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
control form macros and protected sheets
I have a large worksheet that requires data entry by other users. There are
both locked and unlocked cells within the worksheet. The database contains several control form macros that cannot run if the sheet is protected. Portions of the worksheet require sheet protection to prevent changes. Is there a way to protect the worksheet and still run the macros? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
control form macros and protected sheets
Place new code in the macros to unprotect the sheet, run the existing
code then protect the sheet. Sub ControlFormMacro Worksheets("LargeWorksheet").Unprotect "password" 'code to do stuff Worksheets("LargeWorksheet").Protect "password" End Sub ---------- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Greyson" wrote in message I have a large worksheet that requires data entry by other users. There are both locked and unlocked cells within the worksheet. The database contains several control form macros that cannot run if the sheet is protected. Portions of the worksheet require sheet protection to prevent changes. Is there a way to protect the worksheet and still run the macros? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run macros on protected worksheet | Excel Worksheet Functions | |||
Run macros on protected worksheet | Excel Worksheet Functions | |||
Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) | |||
allow macros in protected worksheet | Excel Worksheet Functions | |||
Running Macros in protected workbook | Excel Worksheet Functions |