Procedure to remove all named ranges

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DoctorV - 30 Sep 2004 13:20 GMT

Don I did use Chip Pearson's module to remove all VBA Code and module
in addition to removing names. There are no modules present in the on
worksheet that we are e-mailin

Reply to this Message

Dave Peterson - 30 Sep 2004 20:20 GMT

And you reviewed the notes at Debra Dalgleish's site???:
http://www.contextures.com/xlfaqMac.html#NoMacros

there have been some posts that say that Solver can leave a name hanging around
that causes this macro warning.

Here's one link:
http://groups.google.com/groups?threadm=3908D8AA.97D7200B%40bigfoot.com

But removing names should kill this warning message.

> Don I did use Chip Pearson's module to remove all VBA Code and modules
> in addition to removing names. There are no modules present in the one
[quoted text clipped - 5 lines]
> DoctorV's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5143
> View this thread: http://www.excelforum.com/showthread.php?threadid=264822

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message