ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   2007/macros not working (https://www.excelbanter.com/excel-worksheet-functions/228701-2007-macros-not-working.html)

hughesdm

2007/macros not working
 
i have update to 2007 office from 2003. Now the macros that were saved in
2003 are not functioning or can't find them. Can anyone help?

Ron de Bruin

2007/macros not working
 
Hi hughesdm

Do you convert the xls files ito a 2007 file format file ?

If you choose xlsx your code is gone.
Choose xlsm or xlsb if you want to keep the code.

It is also possible that your protection is set to High
Office ButtonExcel Options...Trust Center
Push on the Trust Center Settings button
Choose Macro Settings


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"hughesdm" wrote in message ...
i have update to 2007 office from 2003. Now the macros that were saved in
2003 are not functioning or can't find them. Can anyone help?



All times are GMT +1. The time now is 10:28 PM.

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