hidden macro

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a workbook that warns of a macro prior to opening.... It is a
workbook I created and that only I use.
What is strange is I cannot find a macro anywhere and I don't remember ever
creating one!
I have looked in the toolbar under macro..... nothing there
I have checked "view code" in each individual sheet.... nothing there

I may have once long ago tried recording one to do something, but I don't
know what!
where else might I look? It doesn't make any difference wether it is
enabled or disabled when I open the book.
thanks
D
 
I'd expect that if you put in the exact error message as exact phrase that
you would pick up lots hits/solutions with a Google Groups search.
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://groups.google.com/advanced_group_search?q=group:*Excel*

Suggest looking at Chip Pearson's page
http://www.cpearson.com/excel/vbe.htm

You have to get rid of all modules in the workbook,
reduce all code stored with sheets and ThisWorkbook to be
empty except for your default --- Option Explicit

All explained on Chip Pearson's page along with a macro
to make the process faster. Of course if you really were
using macros in the workbook they will be gone.
 
Back
Top