Excel Macros Disabled
 

My work computer was recently refreshed, and the new machine that I got is
running Win XP Pro and Office 2003.

Since I received the new computer, I have experienced a problem in opening
Excel files containing macros. The scenario is, I open an Excel file that
lives on a network shared drive. Since my Excel Macro Security setting is
Medium, I normally get a dialog box asking me if I want to enable the
macros. However, sometimes this does not happen. The file opens without
showing the dialog box, and the macros are disabled. I have to close the
file and then re-open it (sometimes several times) before I can get the
dialog box that lets me enable macros. I have reproduced the problem on a
couple of neighbors' computers, so it's not just my machine.

The facts that seem pertinent to this situation a

- The Excel files are stored on network shared drives. The drives are
mapped as virtual hard disks.
- Excel Macro Security is set to Medium.
- The problem only seems to happen on machines running Win XP Pro. It has
happened on more than 1 machine.
- The problem is intermittent. One time a given file will open properly,
the next time it won't.

Do any of you have any idea why my files will sometimes open without giving
me the change to enable macros? Is there anything I do to correct this
situation?

-- David

Excel Macros Disabled
 

First, I don't have any idea...does the problem go away if you copy the file to
your local C: drive?

If yes, maybe (over my head) it's a network problem and it's time to get the IT
boys and girls involved.

Good luck.

Ps. If you find the solution, please post back. It may help the next googler.

David Benson wrote:

My work computer was recently refreshed, and the new machine that I got is
running Win XP Pro and Office 2003.

Since I received the new computer, I have experienced a problem in opening
Excel files containing macros. The scenario is, I open an Excel file that
lives on a network shared drive. Since my Excel Macro Security setting is
Medium, I normally get a dialog box asking me if I want to enable the
macros. However, sometimes this does not happen. The file opens without
showing the dialog box, and the macros are disabled. I have to close the
file and then re-open it (sometimes several times) before I can get the
dialog box that lets me enable macros. I have reproduced the problem on a
couple of neighbors' computers, so it's not just my machine.

The facts that seem pertinent to this situation a

- The Excel files are stored on network shared drives. The drives are
mapped as virtual hard disks.
- Excel Macro Security is set to Medium.
- The problem only seems to happen on machines running Win XP Pro. It has
happened on more than 1 machine.
- The problem is intermittent. One time a given file will open properly,
the next time it won't.

Do any of you have any idea why my files will sometimes open without giving
me the change to enable macros? Is there anything I do to correct this
situation?

-- David

--

Dave Peterson