If you meant the code I gave you doesn't work for you, it may be that you
have a later version of Excel that restricts access to the VBProject. I'm
running xl2000 and don't have a problem.

Check ToolsMacroSecurity and check to see if there is a "Trust access to
VBProject" checkbox in one of the tabs. I don't have this but have seen it in
later versions. If so, make sure this checkbox is checked. Otherwise, it is
likely a security issue that I'm not up to date with.

Regards,
Greg

"davidm" wrote:


Many thanks Greg. For some reason, that code has never worked for me,
logical as it is (and with Microsoft Visual Basic for Applications
Extensibility reference enabled). I would welcome any feedback on
this.

[ps: I am sorry for the multiple postings of the initial thread. It was
due to server problems I was encountering and which made it hard to
authenticate submissions].


David


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=526630