hi,
I have a sheet with many formulas I will use in a user form I want to hide this sheet and put a password on my macros and all the codes how to do that?
hi,
I have a sheet with many formulas I will use in a user form I want to hide this sheet and put a password on my macros and all the codes how to do that?
You can set the Sheet's Visible Value in the VBE Properties of that sheet. Make it VeryHidden
To protect your code, open the VB Editor Alt+F11. Now, from within the VBE go to Tools>VBAProject Properties and then click the Protection page tab and then check "Lock project from viewing" and then enter your password and again to confirm it. After doing this you must save, close & reopen the Workbook for the protection to take effect.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank you very much Roy,
I will try it and get to you later
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks