MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Workbook you are opening contains Macros...

Posted by Tracy on December 18, 2001 11:10 AM

I get the above message when opening a workbook. There are no macros for this workbook and when I go to tools, macros, there are none listed. How do I turn this off? One sheet of the workbook acts as though it's trying to do something and my CPU utilization goes up to 70% to 96% for excel.exe. When I click onto another sheet of the workbook the CPU utilization goes back to normal.

Posted by Jim on December 18, 2001 11:29 AM

Hi Tracy,

keypress alt f11
click on the project explorer icon
and the have a look at ThisWorkbook, modules etc.

If the were written "Private" they wouldn't be
seen where you were looking.


Posted by Tracy on December 18, 2001 11:52 AM

Thanks Jim,
There are some things listed for the VBA project. I especially checked the sheet that locks up. example: Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Which functions should I be looking at? What next?

Posted by Jim on December 18, 2001 12:01 PM


Save your workbook as another name and do your
"experimenting" in that book. Then you can remove
the code, close out, open and see what effect
removing the code had on your workbook. If the
workbook needed the code to perform worksheet change
functions it won't work as it was designed to.
Remember all of the above is in a re-named book
not the original

Jim Thanks Jim,