answersLogoWhite

0


Best Answer

There can be many reasons why your macros are not working. Check security settings to ensure your version of Excel has macros enabled. Many times, the default installation disables the ability to use macros. Ensure you accept security certificates for the author of the macros.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you get Macros to work on newer versions of Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What versions of Microsoft Excel are supported by Windows XP Home Edition?

All versions of Excel should work with all versions of Windows.


What has the author Wayne Strong written?

Wayne Strong is the author of "Mastering Excel Macros: Introduction," a book that focuses on helping users learn and use macros efficiently in Microsoft Excel. Strong's work aims to provide practical guidance and tips to maximize productivity when working with Excel macros.


What is the purpose of the Compatibility Checker and saving in a backwards-compatible file format?

It has to do with who will be using your files and what versions of the software they have. Virtually all major software packages, including Microsoft Office, are backward-compatible, which means that you can work with files that were saved in older versions of the software. However, you often cannot open files saved in newer software versions if you are using an older version. For example, in Excel 2007, in addition to the normal Save function, you also have the option of saving your workbook as an Excel 97-2003 file. Both the normal save and the 97-2003 save have their drawbacks. If you save your file normally, you are limiting the range of your audience, because people using older versions of Excel won't be able to open it. If you save it as a 97-2003 version, you are limiting what functions you can use to make the file look and behave the way you want. Obviously, every new software version has more "bells and whistles" than the previous version. By saving as a 97-2003 version, you are limiting yourself to only the functions that were available in those older software versions. When using a newer Excel version and saving your workbook as an older format, the Compatibility Checker will let you know what characteristics of your workbook, if any, are not compatible with the version in which you are trying to save it. Of course, if your file is only for your personal use, you need not concern yourself with the 97-2003 save option. BTW, you can tell which Excel files are compatible with Excel 97 etc. by the file extension. Files saved in newer Excel versions and that are not compatible with the older versions have four-letter extensions instead of three-letter. For example, for regular Excel files (not templates, no macros, etc.), older versions have the extension .xls, and newer versions have the extension .xlsx.


Will high definition cables work with an arcade xbox 360?

IF you have the newer versions hdmi cables will work on the xbox.


How is MS Excel acquired?

You have to buy it. You can download trial versions, but they only work for a limited time. You can also get illegal versions, but that is obviously not advisable.


Who invented Excel 2007?

Excel 2007 is just an update of previous versions of Excel. No one individual is responsible for creating it. It is the work of many programmers employed by Microsoft going back over many years.Excel 2007 is just an update of previous versions of Excel. No one individual is responsible for creating it. It is the work of many programmers employed by Microsoft going back over many years.Excel 2007 is just an update of previous versions of Excel. No one individual is responsible for creating it. It is the work of many programmers employed by Microsoft going back over many years.Excel 2007 is just an update of previous versions of Excel. No one individual is responsible for creating it. It is the work of many programmers employed by Microsoft going back over many years.Excel 2007 is just an update of previous versions of Excel. No one individual is responsible for creating it. It is the work of many programmers employed by Microsoft going back over many years.Excel 2007 is just an update of previous versions of Excel. No one individual is responsible for creating it. It is the work of many programmers employed by Microsoft going back over many years.Excel 2007 is just an update of previous versions of Excel. No one individual is responsible for creating it. It is the work of many programmers employed by Microsoft going back over many years.Excel 2007 is just an update of previous versions of Excel. No one individual is responsible for creating it. It is the work of many programmers employed by Microsoft going back over many years.Excel 2007 is just an update of previous versions of Excel. No one individual is responsible for creating it. It is the work of many programmers employed by Microsoft going back over many years.Excel 2007 is just an update of previous versions of Excel. No one individual is responsible for creating it. It is the work of many programmers employed by Microsoft going back over many years.Excel 2007 is just an update of previous versions of Excel. No one individual is responsible for creating it. It is the work of many programmers employed by Microsoft going back over many years.


Is word 2002 compatible with word 2003?

All previus versions of Microsoft Word work on the newer versions, but for the newer vesions to work on the older vesions you have to got to save as and then under where you type the name of the document, scroll down and select the version you want it to be compatible with.


When was ascii created?

Work began on it in 1960. The first version came out in 1963. There have been newer versions since then.


Can Excel 2010 formulas be used in Excel 2003?

Formulas that work in Excel 2010 will work in any of the older versions of Excel. The main difference from 2007 onwards is the way Excel looks. Fundamentals like how standard formulas are used never changes. It is still a spreadsheet. If they cannot do those standard things then they are not really spreadsheets.


Do Game Boyadvanced games work on the Game Boy Color?

No, it does not work that way. GameBoy Advance games are newer than the GameBoy Color, so the GameBoy Color system cannot support the game. However, you can play GameBoy Color games on a GameBoy Advance system if you want.


What are some of the features of zMUD?

zMud is a Telnet client. It includes numerous features such as: GUI client, aliases, spell checking, and macros. This program does not work on Windows Vista (and higher versions) and it is recommended that CMUD be used instead.


Can a project done in sql 2005 run in sql 2008?

Sure, but only if you know which commands/functions work in the newer version, because in newer versions, more commands/functions are developed, and some things are removed.