Hi,
#1. You would need to put the users Excel Macro Security to Low which is
generally considered dangerous because it applies to ALL Excel files opened
on that user's machine. You might consider:
"If you haven't already done so, set the macro (macro: An action or a set of
actions you can use to automate tasks. Macros are recorded in the Visual
Basic for Applications programming language.) security level to Medium or
High.
How?
On the Tools menu, click Options.
Click the Security tab.
Under Macro Security, click Macro Security.
Click the Security Level tab, and then select the security level you want to
use.
Open the file or load the add-in (add-in: A supplemental program that adds
custom commands or custom features to Microsoft Office.) that contains
macros certified by the macro developer that you want to add to the list.
In the Security Warning box, select the Always trust macros from this
publisher check box.
Note If the Security Warning box does not display the Always trust macros
from this publisher check box, the macros are not digitally signed (digital
signature: An electronic, encryption-based, secure stamp of authentication
on a macro or document. This signature confirms that the macro or document
originated from the signer and has not been altered.). You cannot add this
macro developer to the list of trusted sources without a digital signature."
This is from the 2003 help system - searching help on "Trusted Publishers"
There are links there to a discussion of digital signatures.
#2: If you mean that you want the macro to not displayed when the Tools,
Macro, Macros dialog box is displayed, then you should make the macro a
Private Sub myMacro()
End Sub
If you mean so they can't get to it in the VBE, then in the VBE choose
Tools, VBA Project Properties, Protection tab,
check Lock project for viewing and add a Password.
Cheers,
Shane Devenshire
Microsoft Excel MVP
