LinkBack URL
About LinkBacks
Hi guys,
'Is there a way to make a module to be hidden? Not to appear it when you press Alt F8 and to see the macro from each module?
I would like to have something like we hide a sheet on a file. Is this possible also in VBA?
Thank you,
Ionut
Hi guys,
'Is there a way to make a module to be hidden? Not to appear it when you press Alt F8 and to see the macro from each module?
I would like to have something like we hide a sheet on a file. Is this possible also in VBA?
Thank you,
Ionut
Last edited by IonutC; 08-26-2016 at 10:02 AM.
Please consider:
Be polite. Thank those who have helped you.
Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
You can password protect the entire VBA Project so that someone cannot open it without the password.
http://www.excel-easy.com/vba/exampl...ect-macro.html
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Thank you!
I want to have a hidden module that is not visible. I don't want to put a pass. I know this, but i need to hide a module that is not visible for other users.
Kr,
Please Login or Register to view this content.
Ionut
To hide the subroutine in a module from Alt + F8 window .. Just add the word Private before the word Sub
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
@ YasserKhalil,
I must admit that I never knew that! How would you access it again should you need to change some of the Code?To hide the subroutine in a module from Alt + F8 window .. Just add the word Private before the word Sub
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
You can simply put form button on the sheet and right-click and assign macro (Before putting the word Private) ..
Then after assigning the subroutine to the button .. log in VBE and add the word "Private" ..
That's all
Thank you for your answer Yasser! After i use the edit mode of the module the module becomes private and clicking the button will hide it and not unhide it anymore....Originally Posted by YasserKhalil
The are a few ways to do it.
As YasserKhalil mentioned you can make the subroutine private. As long as you can remember the routine name you can still use ALT+8 to assign macro even if the routine is not in the list.
You can make the routine a function.
You can also add the following command to the top of the module so all routines within module will be excluded.Please Login or Register to view this content.
Once assigned the Edit button on macro dialog should still work. Or you can easily get to the code by using ALT+F11 to open VBE editor and the CTRL+FPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks