Disable Macros Excel

[jwkolker]

Hi.

I deliver multiple reports on a daily basis. I call about 3 macros per report from within MSAccess that prepare the files for presentation. When I am all done, I would like to either delete the macros or change the settings of the file so that my end users do not get a nag screen asking them to enable or disable macros in the file. I do not want the end users to change any settings at their end I just want the nag screens to go away.

Any help will be appreciated.

John John Kolker
Programmer
jwkolker@comcast.net

 

[VicM]

jwkolker:

As I understand it, the macros are housed in Excel and you execute them from within Access. If that's correct then I'm assuming you have already established an Excel object in code in a subroutine in Access.

Why not just move the macro code from Excel into the subroutine in Access that you use to call those macros? That way there will be no macros in the Excel spreadsheet to generate the warning box.

Hope this helps,

Vic

 

[jwkolker]

Hi Vic:

Yes that is one way that I am considering - the other way is to have a "mastermacros.xls" where I use the xls file to house all the macros and call them thru that file... I was just hoping that there was a command that I could use on exiting a file that would allow me to "disable" all macros for the end user...

Thanks again.

John John Kolker
Programmer
jwkolker@comcast.net

 

[VicM]

jwolker:

I tried doing the same thing once. Spent lots of time trying to force the warning box not to display. Was unable to achieve desired result. :-(

Vic