How to run macros automatically whenever Excel is opened.

[premMS143]

Hi,

I have written one macro, in which it avoids printing whenever user clikcs on 'Print'. Its working fine. But when we open Excel, its asking "Macros are disabled. Do you want this macro to be enable...?" .

When this pop ups, user wont click on this. They simply give printouts. So I need this macro to be run automatically whenever we open this excel file.
I tried with writing macro on personal macro workbook also. But still its not working.


Thanx in advance

[NeoPa]

This is a security feature and reflects the Macro / Security setting on an individual installation of Excel on a PC.

You could change the settings on all PCs that you control, or you could sign all your trusted work, and ensure all necessary PCs trust your signature (See Code Signing).