Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
TY TY is offline
external usenet poster
 
Posts: 5
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.programming
TY TY is offline
external usenet poster
 
Posts: 5
Default 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






  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Check a sheet each time file opened? Don Excel Discussion (Misc queries) 1 February 24th 09 06:27 PM
use check box created in Excel 2003 opened in Excel 2007 TommyB Excel Worksheet Functions 1 February 21st 09 02:01 AM
Increase size of a Forms Check Box (click on to enter check mark) 718Satoshi Excel Discussion (Misc queries) 0 August 17th 07 01:52 AM
how to make excel 2007 open 2 wokbooks in 2 different windows Ofer Gal Excel Discussion (Misc queries) 1 May 5th 07 09:29 AM
How to check if the Excel VBE is opened within Excel? wellie Excel Programming 1 July 14th 03 04:25 PM


All times are GMT +1. The time now is 07:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"