Thanks Darryl - I caught that right when I clicked on
"send" and thought
"d'OH!!!!!!!!!!!!!!!" LOL
Colin - Let me know if you want me to send the file
off-list. I'm still
looking for the website where I found it...
-Jimm
Darryl Collins
<Darryl.Collins C
OLESMYER.COM.AU>
To
Sent by: MS Excel EXCEL-GPEACH.EASE.LSOFT.COM
General Q & A
cc
List
<EXCEL-GPEACH.EA
Subject
SE.LSOFT.COM> Re: Long, sorry:
Custom Toolbars
(or: scope in
multiple similar
workbooks)
01/31/2007 05:04
PM
Please respond to
MS Excel General
Q & A List
<EXCEL-GPEACH.EA
SE.LSOFT.COM>
Jim,
Best ask Mr Colin Roberts as it is his question. I just
passed it on 
regards
Darryl
-----Original Message-----
From: MS Excel General Q & A List
[mailto:EXCEL-GPEACH.EASE.LSOFT.COM]On Behalf Of Jimm
Johnson
Sent: Thursday, 1 February 2007 12:02 PM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Re: Long, sorry: Custom Toolbars (or: scope in
multiple similar
workbooks)
Hey Darryl
I had this same problem and found a nifty workaround that
creates a toolbar
within each worksheet even with >1 file (based on that
worksheet) open. It
uses VBA code to build a toolbar from data stored in a
hidden worksheet
within the workbook. It's slick and way easier than having
all the VBA
code. I can't find a reference in my email database telling
me where I
found it but I know it was one of the really good Excel
resource sites like
Ozgrid - I'll have to google and see if I can find it.
In the meantime, I can send you a blank copy of the
worksheet off-list if
you want - let me know. I think you could look at it and
figure it out.
-Jimm
Darryl Collins
<Darryl.CollinsC
OLESMYER.COM.AU>
To
Sent by: MS Excel EXCEL-GPEACH.EASE.LSOFT.COM
General Q & A
cc
List
<EXCEL-GPEACH.EA
Subject
SE.LSOFT.COM> Re: Long, sorry:
Custom Toolbars
(or: scope in
multiple similar
workbooks)
01/31/2007 04:48
PM
Please respond to
MS Excel General
Q & A List
<EXCEL-GPEACH.EA
SE.LSOFT.COM>
Colin,
I am going to post this one on the Excel - L list as well
for you.
-----Original Message-----
From: MS Excel General Q & A List
[mailto:EXCEL-GPEACH.EASE.LSOFT.COM]On Behalf Of Colin
Roberts
Sent: Thursday, 1 February 2007 11:36 AM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Long, sorry: Custom Toolbars (or: scope in multiple
similar
workbooks)
Hi,
I'm a newbie to this list but have a fair amount of
experience with Excel
and VBA.
I have a fairly urgent problem that I'm hoping someone can
help me with.
All
of the suggestions I've found don't actually answer my
specific question
and
looking at the Excel online Help, I get the impression it
can't be done
but... my experience on the MS Word ListServ makes me
believe that if
there's a way, someone will know it.
Summary: I can't find a way to load into the Application a
custom toolbar
stored in the ActiveWorkbook when the workbook is already
open.
I have defined a custom toolbar in a workbook that is served
(as an XLS) on
an intranet.
Users download and save the workbook to their local machine.
They might do
this several times because the workbook might be used for
multiple
projects.
When the workbook is the only one of its kind that is open,
the custom
toolbar works fine. I have implemented the technique
presented in the
OzGrid
Web site (
http://www.ozgrid.com/VBA/toolbar-remove-restore.htm) to
show,
hide and delete the toolbar according to the specific
events.
With several workbooks opened but only one of this type,
everything works
great. However, when several workbooks based on the same
source workbook
are
opened, it seems that only the first toolbar is loaded into
the
Application.
This remains true even after I close the first opened
workbook with the
result that although the toolbar is still visible, clicking
a button on it
reopens the original file. If I use the code to delete the
custom toolbar,
the remaining workbook causes an error. I can't find a way
to load into the
Application the custom toolbar stored in the ActiveWorkbook
when the
workbook is already open.
(I hope this is clear.)
Due to the customer's setup, I can't develop an XLT type
environment or
implement an Addin. (What I'm really saying is that at this
stage in the
job, it would be embarassing to propose this without having
thoroughly
researched the possibilities.) :^(
What I'm looking for is a solution that will change the
reference to the
toolbar so that it points to the ActiveWorkbook and not to
the first
workbook that loads it.
Phew! I hope someone can help me.
Cheers
Colin
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
This email and any attachments may contain privileged and
confidential
information and are intended for the named addressee only.
If you have
received this e-mail in error, please notify the sender and
delete this
e-mail immediately. Any confidentiality, privilege or
copyright is not
waived or lost because this e-mail has been sent to you in
error. It is
your responsibility to check this e-mail and any attachments
for viruses.
No warranty is made that this material is free from computer
virus or any
other defect or error. Any loss/damage incurred by using
this material is
not the sender's responsibility. The sender's entire
liability will be
limited to resupplying the material.
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
This email and any attachments may contain privileged and
confidential
information and are intended for the named addressee only.
If you have
received this e-mail in error, please notify the sender and
delete this
e-mail immediately. Any confidentiality, privilege or
copyright is not
waived or lost because this e-mail has been sent to you in
error. It is
your responsibility to check this e-mail and any attachments
for viruses.
No warranty is made that this material is free from computer
virus or any
other defect or error. Any loss/damage incurred by using
this material is
not the sender's responsibility. The sender's entire
liability will be
limited to resupplying the material.
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|