ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro in Excel 2007 (https://www.excelbanter.com/excel-programming/392638-macro-excel-2007-a.html)

ViestaWu

Macro in Excel 2007
 
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?

Jim Rech

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

--
Jim
"ViestaWu" wrote in message
...
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?




ViestaWu

Macro in Excel 2007
 
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 ?

"Jim Rech" wrote:

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

--
Jim
"ViestaWu" wrote in message
...
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?






All times are GMT +1. The time now is 01:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com