How do you delete database macro?

[jamaz]

Hi,

I used the template wizard to create and populate a database
automagically. This process created a macro that is NOT visible in the
Tools/Macros window. I now want to dis-associate the template from the
database but cannot find a way to do so without re-creating the
template....

Any help would be appreciated.

jan

 

[IC]

Hi,

I used the template wizard to create and populate a database
automagically. This process created a macro that is NOT visible in the
Tools/Macros window. I now want to dis-associate the template from the
database but cannot find a way to do so without re-creating the
template....

It's probably VBA code. With the sheet open, pres Alt-F11 to open the VBA
editor and delete the code in there. Make sure there's nothing in there you
need before doing this.

Ian

 

[jamaz]

tried that - nothing there.... (thanx for suggestion

 

[Dave Peterson]

You may want to double check for code--it can hide in a few spots.

Debra Dalgleish has some instructions at:
http://www.contextures.com/xlfaqMac.html#NoMacros

And are you sure that the code is in the workbook with the data? It could be in
a separate workbook.

When you're in the VBE (looking for code), hit ctrl-r to see the project
explorer.

What files do you see there? Some are normal addins used in excel and some will
belong to the workbooks you have open.

But maybe there's another one.

I see this in mine:
funcres (FUNCRES.XLA) (anaylsis toolpak for Excel stuff)
personal (personal.xla) (my own set of macros/functions)
VBAProject (book1) (initial empty workbook)