Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need To Protect "Tab code"
I have code within a tab, for example a "Private Sub
Worksheet_SelectionChange...". I was suprised that although I PROTECT the worksheet with a password, the code within the tab is still accessible and be modified. How can this too be protected from anyone updating it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need To Protect "Tab code"
Protect the VBAProject
http://www.ozgrid.com/VBA/protect-vba-code.htm -- Regards Dave Hawley www.ozgrid.com "GEdwards" wrote in message ... I have code within a tab, for example a "Private Sub Worksheet_SelectionChange...". I was suprised that although I PROTECT the worksheet with a password, the code within the tab is still accessible and be modified. How can this too be protected from anyone updating it? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need To Protect "Tab code"
Dave,
Fantastic! You have helped me again. MANY thanks. "ozgrid.com" wrote: Protect the VBAProject http://www.ozgrid.com/VBA/protect-vba-code.htm -- Regards Dave Hawley www.ozgrid.com "GEdwards" wrote in message ... I have code within a tab, for example a "Private Sub Worksheet_SelectionChange...". I was suprised that although I PROTECT the worksheet with a password, the code within the tab is still accessible and be modified. How can this too be protected from anyone updating it? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need To Protect "Tab code"
You can protect all the code (the entire workbook's project, actually), by:
Opening your workbook Open the VBE (alt-f11 is a quick way to get there) Show the project explorer (ctrl-r) Select your project Tools|VBAProject Properties|Protection tab Give it a nice (memorable!) password. Back to excel Save, close, and reopen the workbook to test. Be aware that like most passwords everywhere, there are ways of cracking it. GEdwards wrote: I have code within a tab, for example a "Private Sub Worksheet_SelectionChange...". I was suprised that although I PROTECT the worksheet with a password, the code within the tab is still accessible and be modified. How can this too be protected from anyone updating it? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect "Copy" and "Save As" changes to workbook | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Add "Protect ALL Sheets" that is the same as "Protect Sheet" | Excel Worksheet Functions | |||
".Protect userinterfaceonly:=True" & ".EnableSelection = xlUnlockedCells" not tabing | Excel Programming |