Hiding Macros
I am using Macros in my excel sheets. I have protected my macro coding by
locking it, so that no one can able to see my macro coding. But I want to protect in such a way that no one can able to see even the names of the macros that I have created. |
Add:
Option Private Module at the top of each module. -- Jim "mrbalaje" wrote in message ... |I am using Macros in my excel sheets. I have protected my macro coding by | locking it, so that no one can able to see my macro coding. | | But I want to protect in such a way that no one can able to see even the | names of the macros that I have created. |
Jim,
I had Added Option Private Module on the top of the module. The macro names are not displayed. But I want to run the macros with the shortcut keys that I have already assigned for it. I tried, but it doesn't work. It is only for the security reason that I want to hide the names and the number of macros that I have created. But i want to use the macro as usual. "Jim Rech" wrote: Add: Option Private Module at the top of each module. -- Jim "mrbalaje" wrote in message ... |I am using Macros in my excel sheets. I have protected my macro coding by | locking it, so that no one can able to see my macro coding. | | But I want to protect in such a way that no one can able to see even the | names of the macros that I have created. |
All times are GMT +1. The time now is 11:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com