Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Worksheet Code Areas
If I protect a worksheet/workbook from having anyone make changes, does this
automatically protect the worksheet code area/s as well? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Worksheet Code Areas
I'm assuming by code areas you mean VB modules containing macros. If that's
the case then protection at the level a worksheet or workbook does not have any effect on your code. Press Alt + F11 to open the Visual Basic Editor and locate the VBA Project window. Normally in the upper-left corner. Locate the VBAProject icon that has your workbook name in parenthesis and right click to open the shortcut menu. From the shortcut menu select VBAProject Properties and in the dialog box that's displayed click the PROTECTION tab. Click the LOCK PROJECT FOR VIEWING checkbox and add and confirm a password. Click OK when done, close the Visual Basic Editor and then resave your workbook. The code is now password protected. -- Kevin Backmann Dallas, TX "retired bill" wrote: If I protect a worksheet/workbook from having anyone make changes, does this automatically protect the worksheet code area/s as well? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Worksheet Code Areas
Kevin, thanks for your input. shall give it a try. Thanks, Bill "Kevin B" wrote: I'm assuming by code areas you mean VB modules containing macros. If that's the case then protection at the level a worksheet or workbook does not have any effect on your code. Press Alt + F11 to open the Visual Basic Editor and locate the VBA Project window. Normally in the upper-left corner. Locate the VBAProject icon that has your workbook name in parenthesis and right click to open the shortcut menu. From the shortcut menu select VBAProject Properties and in the dialog box that's displayed click the PROTECTION tab. Click the LOCK PROJECT FOR VIEWING checkbox and add and confirm a password. Click OK when done, close the Visual Basic Editor and then resave your workbook. The code is now password protected. -- Kevin Backmann Dallas, TX "retired bill" wrote: If I protect a worksheet/workbook from having anyone make changes, does this automatically protect the worksheet code area/s as well? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Worksheet Code Areas
Just to add, password protected code is notoriously weak, best to consider
as a deterrent against the casual user tampering with your code but no more. For code in a worksheet module password protection is virtually non-existent. All you need to do is copy the sheet to a new workbook and open the project (might also need select a sheet that doesn't have any code and copy the pair). Regards, Peter T "Kevin B" wrote in message ... I'm assuming by code areas you mean VB modules containing macros. If that's the case then protection at the level a worksheet or workbook does not have any effect on your code. Press Alt + F11 to open the Visual Basic Editor and locate the VBA Project window. Normally in the upper-left corner. Locate the VBAProject icon that has your workbook name in parenthesis and right click to open the shortcut menu. From the shortcut menu select VBAProject Properties and in the dialog box that's displayed click the PROTECTION tab. Click the LOCK PROJECT FOR VIEWING checkbox and add and confirm a password. Click OK when done, close the Visual Basic Editor and then resave your workbook. The code is now password protected. -- Kevin Backmann Dallas, TX "retired bill" wrote: If I protect a worksheet/workbook from having anyone make changes, does this automatically protect the worksheet code area/s as well? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protect VB-code | Excel Discussion (Misc queries) | |||
Naming Areas on Worksheet (Excel 2002) | Excel Worksheet Functions | |||
Protected Worksheet - tabs stop working in certain areas | Excel Discussion (Misc queries) | |||
Code to protect sheet | Excel Worksheet Functions | |||
password protect vba code | Excel Discussion (Misc queries) |