View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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?