"The following features cannot be saved in macro-free workbooks"

Question

"The following features cannot be saved in macro-free workbooks"

Anonymous

Original Title: Save without macro

Hi

I have a excel template with a macro in it (to set a static date)

I want to save it as a workbook without the macro and without the warning:

"The following features cannot be saved in macro-free workbooks"

Please help

Jacob

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

Hi Jacob

Presumably the macro runs when a new file is opened from the template? If so, put something like this at the end of the macro:

Application.DisplayAlerts = False

ActiveWorkbook.SaveAs "C:\My File.xlsx", xlOpenXMLWorkbook

Application.DisplayAlerts = True

Setting DisplayAlerts to False stops the warning from being displayed.

Obviously replace the path & filename with something appropriate. If you want to prompt the user to choose the file name & path you will need to adopt something like this to retrieve it.

Cheers

Jeff

Share via

"The following features cannot be saved in macro-free workbooks"

0 additional answers