Macros in Excel (Office 2007)


D

Deeny H

When I open a spreadsheet created in 2003 Excel, Office 2007 disables the
associated macros. Is there a way to create macros in Office 2007 and save
them so that every time I open the spreadsheet I can utilize those macros?

Thank you!!
 
Ad

Advertisements

J

JoeSpareBedroom

Deeny H said:
When I open a spreadsheet created in 2003 Excel, Office 2007 disables the
associated macros. Is there a way to create macros in Office 2007 and
save
them so that every time I open the spreadsheet I can utilize those macros?

Thank you!!


If Excel 2007 is anything like Office 2000, this might save you the trouble
of creating new macros: Click Tools, Macros, Security. You may see 3
possible security settings for macros. One of them might be causing the
problem.
 
D

Deeny H

Thanks for your quick response. I'll give your suggestion a try and cross my
fingers!
 
Ad

Advertisements

J

JoeSpareBedroom

I think there's an "Ask me each time" choice, which is a good idea if you
get spreadsheets from other people whose computer cleanliness can't be
trusted. In other words, anyone but yourself.
 

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

Top