Excel prompting to disable macros when there are none

E

Electric Monk

Hi,
I'm running Excel 2003 and whenever I start this particular file, I'm
prompted if I want to disable or enable the macros. The thing is that
I used to have a recorded macro (not VBA) assigned to a shortcut key,
but deleted it - and it's not there when I go through the tools menu.

Can anyone tell me how to find whatever is triggering this message?

TIA


Brett
 
H

Herb Tyson [MVP]

The same thing happens in Word 2003 after you've deleted a macro. The fact
that it existed sets some kind of internal flag and deleting the macro
doesn't turn it off.

I've had some luck in removing the now-empty module that contained the macro
(in the VBA editor). That usually tells Word that the file now contains no
macros. You might give that a try.
 
G

gls858

Electric said:
Hi,
I'm running Excel 2003 and whenever I start this particular file, I'm
prompted if I want to disable or enable the macros. The thing is that
I used to have a recorded macro (not VBA) assigned to a shortcut key,
but deleted it - and it's not there when I go through the tools menu.

Can anyone tell me how to find whatever is triggering this message?

TIA


Brett
Click to expand...

i had this problem quite some time ago. If you do Alt F11 it will pop up
the VB editor. there's a module there that needs to be deleted there but
I can't remember what it was called I think it was just called Module1.
If you don't have any macros on the sheet you should be able to delete it.

gls858
 
H

Harlan Grove

Electric Monk said:
I'm running Excel 2003 and whenever I start this particular file,
I'm prompted if I want to disable or enable the macros. The thing is
that I used to have a recorded macro (not VBA) assigned to a shortcut
key, but deleted it - and it's not there when I go through the tools
menu.

Can anyone tell me how to find whatever is triggering this message?
Click to expand...

Generally best to ask Excel-specific questions in Excel-specific
newsgroups, like microsoft.public.excel. Others have reported this
problem, and there are several responses in the Google Groups archive.

It's not enough to delete specific macros. There must be no general
modules, no userforms and nothing more than Option and global variable
declarations in class modules to avoid triggering the macro warning.
 
E

Electric Monk

i had this problem quite some time ago. If you do Alt F11 it will pop up
the VB editor. there's a module there that needs to be deleted there but
I can't remember what it was called I think it was just called Module1.
If you don't have any macros on the sheet you should be able to delete it.

gls858
Click to expand...

Thanks, mate - that did the trick. I thought I'd checked all the VBA
stuff, but had missed this. And you were right, it was called Module1.
Thanks again!

Brett
 
G

gls858

Electric said:
Thanks, mate - that did the trick. I thought I'd checked all the VBA
stuff, but had missed this. And you were right, it was called Module1.
Thanks again!

Brett
Click to expand...
Hey sometimes even an old dog finds a bone:) Glad to help.

gls858
 
Top