ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I check opened wokbooks? (https://www.excelbanter.com/excel-programming/288900-how-do-i-check-opened-wokbooks.html)

TY

How do I check opened wokbooks?
 
How do I check in an addin that it has already been opened?

If open an addin, it will prompt me to enable or disable macro.
I said yes the first time. If I open the same file from Windows Explorer, I
will be prompted again.

Thanks.

TY



Bob Phillips[_6_]

How do I check opened wokbooks?
 
You are not supposed to open it, but install it from ToolsAdd-Ins and then
browse for the file and check it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"TY" wrote in message
...
How do I check in an addin that it has already been opened?

If open an addin, it will prompt me to enable or disable macro.
I said yes the first time. If I open the same file from Windows Explorer,

I
will be prompted again.

Thanks.

TY





TY

How do I check opened wokbooks?
 
There are situations when opening certain workbooks, the addin is desired to
be opened in Workbook_Open() event.

"Bob Phillips" wrote in message
...
You are not supposed to open it, but install it from ToolsAdd-Ins and

then
browse for the file and check it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"TY" wrote in message
...
How do I check in an addin that it has already been opened?

If open an addin, it will prompt me to enable or disable macro.
I said yes the first time. If I open the same file from Windows

Explorer,
I
will be prompted again.

Thanks.

TY







Bob Phillips[_6_]

How do I check opened wokbooks?
 
But if you install, it is always available, and doesn't need to be opened
just for particular workbooks.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"TY" wrote in message
...
There are situations when opening certain workbooks, the addin is desired

to
be opened in Workbook_Open() event.

"Bob Phillips" wrote in message
...
You are not supposed to open it, but install it from ToolsAdd-Ins and

then
browse for the file and check it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"TY" wrote in message
...
How do I check in an addin that it has already been opened?

If open an addin, it will prompt me to enable or disable macro.
I said yes the first time. If I open the same file from Windows

Explorer,
I
will be prompted again.

Thanks.

TY










All times are GMT +1. The time now is 05:40 PM.

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