How do I enable macros in a 1997-2003 spreadsheet in Excel 2007

G

Guest

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
 
G

Guest

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.
 
N

Niek Otten

Office button (Top left)>Excel Options>Popular>Show developer tab in the ribbon
Developer tab>Macro security>Enable all macros

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why is Excel amending formatting itself, when i sort a sheet? 1
ENABLE MACROS 2
Excel 2003 to Excel 2007 3
Make 2007 macros work in 2003 1
Excel 2007 enabling macros 3
Macros in Excel 4
Assigning Macros in Excel 2007 1
Excel 2007 spreadsheet references older office spreadsheets 2

Top