Macros

[Dino]

I have a spreadsheet that I created, where I once set up a
macro to aid in data input. I have since removed that
macro (and there are no macros listed when I go to the
macro listing window). But every time I open this
spreadsheet, it always asks if I want to enable or disable
the contained macros! How can I get rid of this message?
If anyone can help, thank you!

Dino

 

[Andy Brown]

Dino,

The actual module that held the macro needs to be removed as well . See
http://www.contextures.com/xlfaqMac.html#NoMacros for how to check & clean
up.

Rgds,
Andy

 

[Norman Harker]

Hi Dino!

Debra Dalgleish has some easy to follow and methodical steps set out
to do this at:

Debra Dalgleish:
http://www.contextures.com/xlfaqMac.html#NoMacros

You can also do it with VBA. See:

Chip Pearson:
http://www.cpearson.com/excel/vbe.htm

You'll need to scroll down about 3/4 of the way down to "Deleting All
VBA Code in A Project.

Having deleted all code, save the workbook! Then close and upon
re-opening you should have lost the message.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Friday 25th July: Barundi (Anniv of 7th
Republic), Cook Islands (Rarotonga: Gospel Day), Costa Rica
(Guanacaste Day), Cuba (National Revolution), Ecuador (Foundation of
Guyaquil Day), Faroe Islands (Vestanstevna), Haiti (Papa Ogou),
Puerto Rico (Constitution Day), Spain (Galicia National Day, Santiago
Day, St. James Day), Tibet (Yalong Cultural Festival), Tunisia
(Republic Day). Observances: Voudon (Papa Ogou St Jacques le Majeur).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Thomas O'Sullivan]

Dino - I have the exact same issue. I have gone over the
spreadsheet with a fine tooth comb. I know there isn't a
macro any in the workbook, there are no hidden tabs, etc..
driving me crazy. I do know that the spreadsheet was
created in one version of Excel and is being used in a new
version.

I'm only writing to commiserate and so I can get word if
there is a resolution. Thanks.

Have fun..

Thomas..

 

[Dino]

Thanks Andy, for your help. I'll try that.

Dino

 

[Dino]

Thanks, I needed that. Have you seen the answers posted to
my message? I'm going to try them.

Dino

 

[Dino]

Thanks Norman, for your help. I will look those references
up.

Dino