xla/xls help needed!
 

I have an addin which has a couple of worksheets and a code module a
the basis of a new file.

I would like the addin to save these 3 items as a new file but when
use something like...

ThisWorkbook.SaveAs Filename:="BalanceSheet.xls"
FileFormat:=xlWorkbookNormal

It saves the file as an xls fine but retains the property...

IsAddin = True

Can I set this to false when saving or does it have to be done anothe
way?

Rgds,
Matt

--
Message posted from http://www.ExcelForum.com

xla/xls help needed!
 

Is this what you need?

ThisWorkbook.IsAddin = False

--
Jim Rech
Excel MVP