Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 68
Default How do I enable macros in a 1997-2003 spreadsheet in Excel 2007

At work we use excel 1997- 2003 Excel spreadsheets .If I want to work on
these at home I can't get the macros working in Excel 2007 . Can someone
please help
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 515
Default How do I enable macros in a 1997-2003 spreadsheet in Excel 2007

Click on Tools, Macro,Security, and set to medium. You will then be prompted
to either enable macros or not, when you open your spreadsheet. Click on
enable.
--
Hth

Kassie Kasselman
Change xxx to hotmail


"Glen" wrote:

At work we use excel 1997- 2003 Excel spreadsheets .If I want to work on
these at home I can't get the macros working in Excel 2007 . Can someone
please help

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,440
Default How do I enable macros in a 1997-2003 spreadsheet in Excel 2007

Office button (Top left)Excel OptionsPopularShow developer tab in the ribbon
Developer tabMacro securityEnable all macros

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Glen" wrote in message ...
| At work we use excel 1997- 2003 Excel spreadsheets .If I want to work on
| these at home I can't get the macros working in Excel 2007 . Can someone
| please help


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 68
Default How do I enable macros in a 1997-2003 spreadsheet in Excel 20

Thanks, but I still could not get the macros to work .
Glen

"Kassie" wrote:

Click on Tools, Macro,Security, and set to medium. You will then be prompted
to either enable macros or not, when you open your spreadsheet. Click on
enable.
--
Hth

Kassie Kasselman
Change xxx to hotmail


"Glen" wrote:

At work we use excel 1997- 2003 Excel spreadsheets .If I want to work on
these at home I can't get the macros working in Excel 2007 . Can someone
please help

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 68
Default How do I enable macros in a 1997-2003 spreadsheet in Excel 20

Thank yo for the prompt & very helpful response but I still failed to
activate the macros for my 1997 -2003 excel spreadsheet on my computer with
Excel 2007
Glen

"Niek Otten" wrote:

Office button (Top left)Excel OptionsPopularShow developer tab in the ribbon
Developer tabMacro securityEnable all macros

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Glen" wrote in message ...
| At work we use excel 1997- 2003 Excel spreadsheets .If I want to work on
| these at home I can't get the macros working in Excel 2007 . Can someone
| please 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
I was using Excel 2007, now 2003 and my Macros won't work Jaynemoggy Excel Worksheet Functions 2 September 21st 07 11:14 PM
Excel 2003 Workbooks with macros (.xls) converted to Excel 2007 Barb Reinhardt Excel Discussion (Misc queries) 6 September 1st 07 06:58 AM
Simple way to enable just my personal macros in Excel (& Office) 2007 LurfysMa New Users to Excel 13 June 12th 07 12:55 PM
Enable macros in 2007 Anita Excel Discussion (Misc queries) 5 February 10th 07 04:24 PM
How to transfer equations from Excel 1997 to Excel 2003 JP Excel Discussion (Misc queries) 2 January 17th 06 09:11 PM


All times are GMT +1. The time now is 05:19 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"