Macro in Excel 2007

G

Guest

I have added a Macro in my workbook, which is edited in Excel 2007, without
any digit certificates. I close it and reopen it, it should have shown me a
running macro warning. but it doesn't. why?
 
J

Jim Rech

Did you save the workbook in one of your trusted locations? Excel
Options->Trust Center->Trusted Locations.
 
G

Guest

According to your route, I have been to the excel trust center. but I failed
to find the place to set the trusted locations. Is it set up in "Trust center
Setup"?

Besides, I find that Excel 2007 has a new file type which uses a new file
extention name as xlsm. what it that ?
 

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

How to call Excel add-in macro from a button… 1
How to run auto-open macro in Excel 2007? 3
Macros Disabled in Excel 2007 3
When something in module is shown as a macro 3
Macro in 2007 2
Macro for all Excel Workbooks to print to PDF 2
Macro command not running in excel 2007 2
Just switched to Excel 2007 from 2003 - Unclear how to enable macros 2

Top