Why are you setting IsAddin in ThisWorkbook, not ACtiveWorkbook?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"antelao" wrote in
message ...

Hi. I'd like to ask how to create new AddIn with my own macros. It is
easy in Excel: File - Save as ... (ms addin).

BUT I want to do this with help of another macro. I tried this:

ActiveWorkbook.SaveAs _
Filename:="C:\MyMacros\MyAddin.xla", _
FileFormat:=xlAddIn
ThisWorkbook.IsAddin = True

but it doesn't work - there is something wrong with file MyAddin.xla.

Can you help me to create correct AddIn ba macro? Thanks for help,
jiri.
Excel 2002


--
antelao
------------------------------------------------------------------------
antelao's Profile:
http://www.excelforum.com/member.php...o&userid=31039
View this thread: http://www.excelforum.com/showthread...hreadid=507572