ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro (https://www.excelbanter.com/excel-programming/300036-macro.html)

C3

Macro
 
What is the best way to ensure that macro are protected from users being
able to view them (worksheet must be unprotected because of editing cells)?

Thanks!



Don Guillett[_4_]

Macro
 
Put this line at the top of the module
Option Private Module

--
Don Guillett
SalesAid Software

"C3" wrote in message
...
What is the best way to ensure that macro are protected from users being
able to view them (worksheet must be unprotected because of editing

cells)?

Thanks!






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

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