How to hide a list of Macros in Excel 2000 (SR 1) and later version of excel like Excel 2003 etc.
2006-07-11 19:53:52 · 5 answers · asked by padam_india 1 in Computers & Internet ➔ Programming & Design
I would like to hide a macros without using password protection functionality. Do we have any other option?
2006-07-11 20:20:50 · update #1
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 sami@excelgoodies.com for more info in this regard.
2006-07-11 22:46:12 · answer #1 · answered by i_am_sami_da 2 · 0⤊ 0⤋
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.
2006-07-12 06:26:31 · answer #2 · answered by Dilip Rao 3 · 0⤊ 0⤋
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
2006-07-11 20:11:35 · answer #3 · answered by Anonymous · 0⤊ 0⤋
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.
2016-10-14 09:28:58 · answer #4 · answered by kincade 4 · 0⤊ 0⤋
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 pepedean@yahoo.com
2006-07-20 04:14:33 · answer #5 · answered by JOSSDEAN 3 · 0⤊ 0⤋