You can enter a SaveAs command in VBA's Immediate window. E.g.,

ThisWorkbook.SaveAs "NewName.xla"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"thinkingfield"
wrote in message
...

I created and saved an .xla file (a couple of custom functions)
and
added it my add-ins. It is always open when I go the the VB
editor and
works fine.

If I want to 'save-as' another name, how can I do this? The
only option
is the regular 'save'.


--
thinkingfield
------------------------------------------------------------------------
thinkingfield's Profile:
http://www.excelforum.com/member.php...o&userid=16181
View this thread:
http://www.excelforum.com/showthread...hreadid=276098