ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Why does code run evry time any xls file is opened (https://www.excelbanter.com/excel-programming/419579-why-does-code-run-evry-time-any-xls-file-opened.html)

mcambrose

Why does code run evry time any xls file is opened
 
When I first startup excel it runs a subroutine that asks me to select a
printer? I can't see any add-ins installed that have this loaded. If there an
application level event that happens every time a file is opened. I don't
know where to look to see where it would be installed. I would think it is
similar to workbook_open event, which is stored in a specific file. Where
would this be stored as an event for all xls files? Thanks for any
suggestions.

Gary''s Student

Why does code run evry time any xls file is opened
 
To see if there is a macro problem, set you Security Level to High and then
start Excel. You will get a warning if a macro is trying to execute.

The macro may b in your Personal.xls, for example.
--
Gary''s Student - gsnu200812


"mcambrose" wrote:

When I first startup excel it runs a subroutine that asks me to select a
printer? I can't see any add-ins installed that have this loaded. If there an
application level event that happens every time a file is opened. I don't
know where to look to see where it would be installed. I would think it is
similar to workbook_open event, which is stored in a specific file. Where
would this be stored as an event for all xls files? Thanks for any
suggestions.


mcambrose

Why does code run evry time any xls file is opened
 
I think I found what is going on. If I don't have a default printer set, then
the listbox comes up to select a printer. This may be something built into
Excel and not something I added. THanks for the suggestion.

"Gary''s Student" wrote:

To see if there is a macro problem, set you Security Level to High and then
start Excel. You will get a warning if a macro is trying to execute.

The macro may b in your Personal.xls, for example.
--
Gary''s Student - gsnu200812


"mcambrose" wrote:

When I first startup excel it runs a subroutine that asks me to select a
printer? I can't see any add-ins installed that have this loaded. If there an
application level event that happens every time a file is opened. I don't
know where to look to see where it would be installed. I would think it is
similar to workbook_open event, which is stored in a specific file. Where
would this be stored as an event for all xls files? Thanks for any
suggestions.



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

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