How to hide a list of Macros in Excel 2000 (SR 1) and later version of excel.?

Question

How to hide a list of Macros in Excel 2000 (SR 1) and later version of excel.?

Answer 1

assume the sheet you prefer to hide is Sheet1 of mybook.xls a million. Alt-F11 to open VBA editor, in challenge explorer(ctrl+r if no longer showing) and double click on Sheet1(Sheet1) icon lower than VBAProject(mybook.xls) 2. in houses window(F4 if no longer showing) lower than, flow to seen that line, click the right replace -a million - xlSheetVisible to at least a million of both different decision(for hiding sheet) 3. keep the worksheet by clicking keep icon in vba editor desire this enables.

Answer 2

ok... you can protect you VBE (visual basic editor) with a password.



Now, if you also want to hide the macros name from the list ... you just need to make them "Private"...



eg



Private Sub MYMacro ()



end sub





If this answers your question... please vote



if you need further help, just send me an email [e-mail]

Answer 3

Even if you prevent the project from being viewed (by using a password) the list of macros still shows in Tools - macro - macros. A user can run a macro from here and really screw up your program. I know that this list can be hidden (I have seen Excel files that have macros, but the 'List' is blank) only I dont know how this is done. I would love to find out how.

Answer 4

In VBE of Excel (Or any other application) you can go to Tools > VBAProject Properties, then go to Protection tab and check the Lock project for viewing and set a password

Answer 5

you cannot hide the macro list in the VBA editor.. u can probably apply a password.. but still users will know that there is a macro in the file, they may probably not be able to look at the code if u use a password.



let me know what exactly ur macro does, its possible to do almost everything u do with a macro using a formula. and a formula can be hidden from the users.



i am a excel consultant. you can contact me at [e-mail] for more info in this regard.