![]() |
|
#9
|
||||
|
||||
|
In the old versions of Excel, up to 2003, workbooks were named .xls and macros were stored directly in the workbooks. But with increasing concern about malicious software, Microsoft introduced a distinction between workbooks that can contain VBA code and those that can't. The plain-vanilla workbook is now .xlsx. If you want to write a macro for one of your workbooks, it won't be saved in an .xlsx; you have to store it with extension .xlsm. This provides a little extra warning about the content to a user opening a workbook, in addition to the warnings that pop up.
I graduated straight from 2003 to 2010, so I don't know whether this distinction started with 2007 or 2010. Does that help? If I skipped over an important part of the explanation, feel free to keep asking. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Summing up values in a Single Merge Field
|
Beowolf | Mail Merge | 1 | 03-07-2014 03:26 PM |
| Finding Earned Values for Different Baselines in a single project | pratik6312 | Project | 1 | 08-22-2013 11:18 AM |
How to count multiple values in a single cell, except zero?
|
iuliandonici | Excel | 1 | 04-13-2011 09:45 PM |
Sum & difference between multiple values in a single cell
|
iuliandonici | Excel | 4 | 04-13-2011 09:27 PM |
How can I write the following (whole) formula in a single cell?
|
Learner7 | Excel | 1 | 07-19-2010 10:06 AM |