Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Check a sheet each time file opened? | Excel Discussion (Misc queries) | |||
use check box created in Excel 2003 opened in Excel 2007 | Excel Worksheet Functions | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
how to make excel 2007 open 2 wokbooks in 2 different windows | Excel Discussion (Misc queries) | |||
How to check if the Excel VBE is opened within Excel? | Excel Programming |