removing macros in Excel 97

  • Thread starter Thread starter Corrie
  • Start date Start date
C

Corrie

I have a few spreadsheets that upon opening ask if I want
to enable or disable the macros. When I open the file
there are no macros and unhiding the sheets shows no
macros as well. I have removed the modules that were
present on the file but to no avail, every time I open the
file it asks the same question. Does anyone know how to
find these hidden macro's. I tried the knowledge database
(article attached) but it didn't work as there are no
ranges or hidden ranges as well. Can someone help, this
is getting frustrating.

http://support.microsoft.com/default.aspx?scid=kb;en-
us;199972&Product=xlw97
 
I would imagine that there must code of some kind in an empty module or in
one of the worksheet modules or in the workbook module. Open them all (Hit
Alt and F11 to open the VB Editor) and delete everything you find. Could
there be a an Excel 4 maco worksheet that is hidden?
 
Back
Top