Macro Warning but No Macro...

[jiminoregon]

I'm stumped. There was a macro in the sheet I'm working on, but I removed it. Still got the macro warning on opening. I went to the project explorer and removed the module...but still get a macro warning.

Any ideas?

 

[nbrcrunch]

Is personal.xls opening in every session?

 

[jiminoregon]

Is personal.xls opening in every session?

I use Excel 2003 and I can't locate a file named personal.xls. Could it have a different name in this version?

Thanks,

Jim

 

[Gary McMaster]

Go into the Workbook & Worsheet events and delete any and all subs. Even if there is, for example, only a Private Sub Workbook_Open()
End Sub with nothing in it, it will still trigger the "Macro warning".

Gary

 

[jiminoregon]

Go into the Workbook & Worsheet events and delete any and all subs. Even if there is, for example, only a Private Sub Workbook_Open()
End Sub with nothing in it, it will still trigger the "Macro warning".

Gary

Thanks...I got it!!!!