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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting a workbook
Alex,
In Excel 2003... Select "Save as" from file menu Select "Tools" at right top area from "Save As" screen Select "General Options" Select "Password to Open" - assign the password to open the file, then retype (User must know the password to open the file) Select "Password to Modify" - assign the password to open the file, then retype (User must know the password to modify the file) Let me know if you need further assistant Roberto - |
Reply |
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) |