View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Smartbiz Smartbiz is offline
external usenet poster
 
Posts: 1
Default Custom Excel 2007 Tab disappears when editing an XLAM add-in f

For editing, you can get create a toolbar that shows on the addins tab..

That stays there and the file can be a .xlsm or .xlam

If you are constantly editing the code, then use the toolbar method and
make it a .xlsm file....

We use the above method for testing as it is easier to test a .xlsm file
than a .xlam file and we have some code that showsthe toolbar if it is a
.xlsm file otehrwise it assumes the file is an addon and the custom
ribbon would be used.

Tom Bizannes
http://www.macroview.com.au
Sydney, Australia

*** Sent via Developersdex http://www.developersdex.com ***