Software

Ask something
Discussion Locked

Workbook you are opening contains macros

0 helpful
7 replies

by tracyp

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a large file 2.5MB, when I open the workbook I get the above message. There are no macros I created. There are no add ons running. When I look at the VBA project area there are some private subs. When I open one particular sheet of the workbook my CPU utilization goes up to 99%. excel.exe is using it. When I click onto another sheet the utilization goes back to normal. I am using Office 97, SR2 with windows NT 4.0 SP6. I did have Visio installed but have removed it. What else should I look for?

7 replies

by dklippert

This may address your problem: Type the Q number in the solutions using box at support.microsoft.com.

Patch Available for Excel 97 Virus Warning Vulnerabilities

Q231304

by stillatit

What may be happening is that there is a macro file in:

C:\Program Files\Microsoft Office\Office\Startup

which Visio was using to put the visio button in the tool bar. Now that the bulk of visio is missing, the macro may be hanging. Go to thatlocation, and remove any Excell files you find there (move them somewhere else for now, kill them later).

Did that particular sheet have a visio drawing on it? If so you may have to reinstall visio, then kill the drawing, then re-delete visio.Good luck.

by tracyp

There is nothing at all in the office start up folder. Also the no sheets in the workbook had a visio drawing.

by tracyp

There is nothing at all in the office start up folder. Also no sheets in the workbook had a visio drawing.

This discussion is closed to new replies.