Missing Save As Add-in option

R

Rhythm

When I try to save my .xlsm file as an Add-in using the Save-As menu command,
the .xlam Add-in option is missing for some .xlsm files but present for other
..xlsm files. Why is this save filetype Add-in not always present?
Any ideas?
 
R

Rhythm

Found my own solution. The active sheet must be a WORKSHEET when performing a
File Save As in order to find the Add-in filetype. My workbook had both
worksheets & and old dialog boxes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save As and new workbook new name used in existing code 8
Workbook does not Save from User Form 4
Saving in .xlsm format by default 6
xlsm.zip files do not show as folders in Explorer 2
Prompt for Save As Window through macro 7
Add-in WITH worksheets?? 1
How to call a macro from a xlam in a xlsm 3
recover xlsm from xlam 1

Top