ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I hide my Visual basic code in Excel? (https://www.excelbanter.com/excel-programming/326980-how-do-i-hide-my-visual-basic-code-excel.html)

geoffc

How do I hide my Visual basic code in Excel?
 
I have produced a workbook for issue to several users and do not want them to
be able to view/alter any of the VBA code I have created. I know how to do
this in Access but cannot find a way in Excel.

Tom Ogilvy

How do I hide my Visual basic code in Excel?
 
Tools, VBAProject Properties and select the Protection tab. VBAProject
would be replaced by the activeproject name.

--
Regards,
Tom Ogilvy

"geoffc" wrote in message
...
I have produced a workbook for issue to several users and do not want them

to
be able to view/alter any of the VBA code I have created. I know how to

do
this in Access but cannot find a way in Excel.




ste

How do I hide my Visual basic code in Excel?
 
in VBA: Menu tools vba_project_properties Protection....



All times are GMT +1. The time now is 06:53 AM.

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