Macro dialog box when opening worksheet

[Guest]

Is there anyway to disable the dialog box that warns a user that a macro is attached to a workbook?

 

[Ben Moore]

That is controlled in the user's installation of Excel under the
security settings, I am not aware of a way to disable this notification
without actually changing the settings on the computer (Tools -> Macros
-> Security)...

cheers,
NeB

 

[Frank Kabel]

Hi
if this would be possible this security feature would be useless. You
cans et the security level to 'Low' (menu: 'tools - Macros - Security')
but I wouldn't recommend this for security reasons

--
Regards
Frank Kabel
Frankfurt, Germany

Is there anyway to disable the dialog box that warns a user that a

macro is attached to a workbook?

 

[Gord Dibben]

Gary

You can create a digital certificate and use that on your VBAProject so that
file with the certificate is allowed to be opened with no warning.

You can get to SelfCert either of these ways........

1. Start>Programs>Microsoft Office>Tools>"Digital Certificate for VBA
Projects"

2. Open Windows Explorer and drill down to your Office folder. Find
SelfCert.exe and run it.

This certificate is good only on your computer but can be used for more than
one file.

Once the certificate has been created and with your file open, go to the
VBEditor and select your VBAproject/file.

Tools>Digital Signature>Choose. Select the Certificate you just created.

OK your way out and save your file.

Next time you open this particular file you will not get the warning.

Gord Dibben Excel MVP

 

[Debra Dalgleish]

If you don't think the workbook has any macros, follow the steps shown
here to get rid of the warning:

http://www.contextures.com/xlfaqMac.html#NoMacros