hide macro
Ho to all,
i have two macro. The first is set by workbook.open, the secon is called from the first and is placed in module1. I want to hide both so the user cannot see them from the excel sheet. What the solution? |
hide macro
Hi GM
if i'm understanding your question correctly, go into the VBE window (Alt & F11) and click on the project name, now right mouse click and choose VBAProject Properties, go to the protection tab and tick "locked for viewing" and enter a password (twice) click OK when the book is closed and reopened you will not be able to view the code without the password. However, please note, that protection in excel is relatively easy to break. Cheers JulieD "GM" wrote in message ... Ho to all, i have two macro. The first is set by workbook.open, the secon is called from the first and is placed in module1. I want to hide both so the user cannot see them from the excel sheet. What the solution? |
All times are GMT +1. The time now is 02:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com