ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel alternate startup file location (https://www.excelbanter.com/excel-programming/315236-excel-alternate-startup-file-location.html)

Jac Tremblay[_3_]

Excel alternate startup file location
 
Hi everyone,

I use Excel 2000 and Excel XP
The macro security is set at Medium in both versions so that I can choose to
run or not the macros present in the files that are opened at startup. In
Excel 2000, I do not get the message asking to run or not the macros while in
Excel 2002 (XP), I get it. Is that normal?

Another point bugs me. In both versions of Excel, the alternate file
location (Tools/Option, General tab) is the same as the Default file
location. All the files (.xlt and .xla) in this 2nd folder are opened at
startup but I do not see all of them in VBE. I only see the XLAs even though
many templates contain macros. Is that also normal?

Thank you.
--
Jac Tremblay


All times are GMT +1. The time now is 07:43 PM.

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