ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I prevent access to code contained within Tab (https://www.excelbanter.com/excel-worksheet-functions/46392-how-can-i-prevent-access-code-contained-within-tab.html)

Lee

How can I prevent access to code contained within Tab
 
I have code contained within the tabs, On Activation
How can I prevent access to this code by other users.

Also how can I prevent access to the normal code ie stop access through the
Tools \ Macro selection.


Regards

Lee

Roger Govier

Hi Lee

Within the VB Editor, choose ToolsVBA Project_PropertiesProtection and set
a password for the project. Do remember to make a note of it.
Regards

Roger Govier


Lee wrote:
I have code contained within the tabs, On Activation
How can I prevent access to this code by other users.

Also how can I prevent access to the normal code ie stop access through the
Tools \ Macro selection.


Regards

Lee



All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com