Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding/Protecting vb code in excel
Hi can anyone tell me how to either hide or protect the vb code on a spread sheet. Thanks Ian ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding/Protecting vb code in excel
Ian,
1. Open the workbook that contains the VBA code 2. Activate the Visual Basic Editor by pressing Alt+F11 in Excel. 3. Tools - VBAProject Properties... 4. On the "Protection" tab, check "Lock project for viewing" and type the same password twice in the textboxes. 5. OK 6. Save the workbook. The VBA code will not be hidden for you at this point, but if you switch back to Excel (Alt+F11), close and re-open the workbook, you will see that the VBA code cannot be seen without providing the password. Ture Magnusson Karlstad, Sweden "IanStrange" wrote in message ... Hi can anyone tell me how to either hide or protect the vb code on a spread sheet. Thanks Ian ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting Code in Visual Basic Editor (Excel 2003) | Excel Worksheet Functions | |||
Hiding and protecting formula | Excel Discussion (Misc queries) | |||
hiding macro codes upon protecting the worksheet | Excel Discussion (Misc queries) | |||
Excel 2003 - Protecting and Hiding Columns | Excel Discussion (Misc queries) | |||
Protecting and Hiding formulas | New Users to Excel |