Macros are disabled

[mkingsley]

I transferred a macro that we use to run a daily report to anothe
computer.
We have to modify the VB code to change the date on the report, eac
day. After installing the macro, it ran the first day, but when the ne
report came, and I tried to modify the macro, by the Step Into men
choice, I get "The macros in this project are disabled" I changed th
security level to Medium, but I still can't open the macro to make th
modification. And when my employee opens any other Excel file they ge
the "Enable Macros, Disable Macros, Cancel".

I am not sure of the relationship between opening Excel files and th
aforementioned menu choice, and the ability to open and modify th
macro I installed.

Any help is appreciated.

Mike Kingsle

 

[Guest]

For security changes to take effect you need to shut excel doown and re-open
it. If the employee chose disable macros then you just need to shut that
spreadsheet down and reopen it then choos enable when asked...

 

[Bill Martin]

For security changes to take effect you need to shut excel doown and re-open
it. If the employee chose disable macros then you just need to shut that
spreadsheet down and reopen it then choos enable when asked...

------------------

Jim answered the question you asked.

On a slightly different subject, why do you need to edit the VBA every day to
change a date setting? Can't you just put the date you want in a known
spreadsheet cell, and have the VBA macro grab that particular date automatically?

Bill