CODEWITHSUNDEEP
vbaexcel-2007
James
James

Reputation: 194

Is there a way to enable macros once in Excel 2007

I have a excel 2007 macro-enabled file (xlsm) that I want to share with a lot of users, but it requires enabling macros each time the spreadsheet is opened.

I know that you can change the macro settings to "enable all macros" and put the spreadsheet in a trusted location. I'm looking for a more user-friendly to do this.

I'm trying to to see if there is another option before having to digitally sign the code.

Office 2010 looks like it will remember that you enable macros. Most of our users have 2007 though.

Upvotes: 1

Views: 805

Answers (1)

Jon49
Jon49

Reputation: 4606

Probably just do what you said, digitally sign, or put in trusted location. You could also create a executable program that opens the workbook that suppresses the macro warning when opening the workbook. Really, there aren't any "friendly" ways of doing this.

Upvotes: 1

Related Questions