Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros not working in Excel 2007 Ayo Excel Discussion (Misc queries) 1 March 25th 09 03:40 PM
Excel 2007 macros - how to merge 5 macros together into one Sue Excel Discussion (Misc queries) 1 April 16th 08 08:36 PM
Macros not working when file run on a Mac Darby Excel Discussion (Misc queries) 4 November 5th 07 02:49 PM
Macros written in UK not working in US Teresa Excel Discussion (Misc queries) 1 April 19th 07 06:59 PM
Working with Macros - Help needed!!! The Greek Excel Discussion (Misc queries) 2 November 19th 06 05:39 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"