How do I check opened wokbooks?

  • Thread starter Thread starter TY
  • Start date Start date
T

TY

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
 
You are not supposed to open it, but install it from Tools>Add-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)
 
There are situations when opening certain workbooks, the addin is desired to
be opened in Workbook_Open() event.
 
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)
 
Back
Top