Procedure to remove all named ranges

[DoctorV]

Don,
Thanks for the tips great stuff!!! One question why is it that when w
email this sheet that now has no code named ranges or objects that it i
prompting the user to enable/disable macros when opening it? There i
nothing but text and a couple of our embedded pictures in it.

Funny thing is that if you open the attachment and save it to a folde
then reopen it later it does not prompt you to enable/disable macros

 

[Dave Peterson]

Take a look at Debra Dalgleish's site for the macro stuff:
http://www.contextures.com/xlfaqMac.html#NoMacros

And I really like Jan Karel Pieterse's (with Charles Williams and Matthew
Henson) Name Manager.

You can find it at:
NameManager.Zip from http://www.bmsltd.ie/mvp

I find that it has so many options, that I load it whenever I want to work with
Names.

 

[Don Guillett]

Names would have nothing to do with macros. You may have cleaned out the
macros and neglected to remove the modules that they were in.