Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting a workbook
Hello
I have created an excel workbook which has 4 worksheets. There are a number if charts in the first worksheet that are driven by data in worksheets 2 to 4. I have written some quite extensive VBA code to drive the charts. I want to protect the workbook so that others can use the workbook but not make amendments to the workbook. I tried ToolsProtectionProtect Workbook... but this failed to protect the workbook. I tried ToolsProtectionProtect Worksheet...which worked. BUT when I pressed some of the buttons on the worksheet to activate the VBA code then the macros failed to work correctly even though they had been fine. So is there a reason why protecting a worksheet would interfere with VBA code...or is it just a bug within Excel... Thanks for any insights that anybody may offer... Alex |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protecting workbook | Excel Discussion (Misc queries) | |||
Protecting a workbook | Excel Discussion (Misc queries) | |||
Protecting a workbook | Excel Discussion (Misc queries) | |||
Protecting Workbook!.. | Excel Worksheet Functions | |||
Protecting Workbook | Excel Discussion (Misc queries) |