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

--
mkingsle
-----------------------------------------------------------------------
mkingsley's Profile: http://www.excelforum.com/member.php...nfo&userid=429
View this thread: http://www.excelforum.com/showthread.php?threadid=47145

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...
--
HTH...

Jim Thomlinson


"mkingsley" wrote:


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

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

Any help is appreciated.

Mike Kingsley


--
mkingsley
------------------------------------------------------------------------
mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
View this thread: http://www.excelforum.com/showthread...hreadid=471459

Jim Thomlinson wrote:
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