Delete reference to macros?

  • Thread starter Thread starter PeterExcel
  • Start date Start date
P

PeterExcel

I used a few small macros to automate the writing of a spreadsheet on my
workplace network.

I deleted the macros when I finished, and there are no macros in the
macro list.

However, when the spreadsheet is opened at a new workstation, the macro
warning box comes up - you can disable macros at one workstation, but
the dialog box comes up at any new workstation.

I would like to prevent this happening if possible. Is there any way to
delete all references to macros used in the spreadsheet?

Thanks for any help. I'm using Excel 97 SR-2 on Windows NT 4.0.

Peter
 
You need to delete any empty modules that housed those macros.

Hit ALT+F11 and this will open the VBE (Visual Basic Editor)
Top left you will hopefully see an explorer style pane. Within this pane you need to
search for
your workbook's name, and when you find it you may need to click on the + to expand it.
Within
that you should see the following:-

VBAProject(Your_Filename)
Microsoft Excel Objects
Sheet1(Sheet1)
Sheet2(Sheet2)
Sheet3(Sheet3)
ThisWorkbook
Modules
Module1
Module2
etc etc (You may have just 1 of these)

If you have named your sheets then those names will appear in the brackets above as
opposed to
what you see at the moment in my note.

Right click on the modules and select remove. When prompted with a question re exporting,
just
hit no. Then hit File / Close and return to Microsoft Excel and save the file.
 
Back
Top