ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro Enabled workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/198210-macro-enabled-workbooks.html)

Polaris

Macro Enabled workbooks
 
What is the advantage or purpose of saving an Excel 2007 workbook as a macro
enabled workbook (.xlsm)

Bob Phillips

Macro Enabled workbooks
 
The advantage is that any macros in it don't get stripped out. 2007
differentiates between just standard spreadsheets and those with macros.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Polaris" wrote in message
...
What is the advantage or purpose of saving an Excel 2007 workbook as a
macro
enabled workbook (.xlsm)




Polaris

Macro Enabled workbooks
 
Yes it does. Thank you!

"Bob Phillips" wrote:

The advantage is that any macros in it don't get stripped out. 2007
differentiates between just standard spreadsheets and those with macros.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Polaris" wrote in message
...
What is the advantage or purpose of saving an Excel 2007 workbook as a
macro
enabled workbook (.xlsm)






All times are GMT +1. The time now is 11:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com