Enable Macro - default //

[sansk_23]

Hi !!

1.) How can i make the workbook open with Macros Enabled - always, w/o user
being asked for the option to choose - Disable or Enable.
2.) Also , the macros written in the file should should not be visible /
accessible to the users. It should be hidden .

Pls. advise.
rgds // Sk.

 

[Norman Jones]

Hi, Sansk_23,

1.) How can i make the workbook open with Macros Enabled - always, w/o
user
being asked for the option to choose - Disable or Enable

I do not believe that this is possible.

The user's ability to choose to enable macros
is an intentional (and proper) design feature.

2.) Also , the macros written in the file should should not be visible /
accessible to the users. It should be hidden .

Try password protecting the VBA project:

In the VBE,

Menus | Tools | VBAProject Properties | Protection |
Lock Project for viewing [x] |
Enter and confirm Password | OK
Save, close and re-open the file.

 

[eggpap]

1.) How can i make the workbook open with Macros Enabled - always, w/o

user
being asked for the option to choose - Disable or Enable.

I think you have just considered to decrease the macro/security level to
low, is it true?
Alternatively, if you don't like to decrease the security level, you can get
a digital certificate
for running Excel Macros under High Macro Security.

http://www.excelsig.org/Tips/0409_digital_certificates.htm

Emiliano

 

[Shane Devenshire]

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