Enable macros when file open.

[ebin charles]

Dear All,

My excel file shows macro notification that Macros are disabled. For more information see attached picture.

I need to open my file with macro activate in any computer. I should not see such notification in any pcs.
When this files is opened the macro should be activate automatically and should open.

Even if other user pcs macro disabled, when he/she tries to open this file, the macro should be enable automatically and should not see
such notification.

Is there any such vba code for "Worksheet_Open"? or any other help please..

Regards,
ebin charles

[Pete_UK]

No, there is no way you can circumvent this.

However, Chip Pearson describes a technique on his website here:

http://www.cpearson.com/excel/EnableMacros.aspx

where you can make a workbook unreadable unless macros are enabled, thus "forcing" the user to enable macros in order to be able to use your file.

Hope this helps.

Pete