Hi All,

I I have more than one window of a workbook, buttons work only on window No.
1.

Can it be achieved somehow that buttons work on other wondows, too?

--
Regards!
Stefi

Many thanks Joel, I'm going to try it.

--
Regards!
Stefi



„joelâ€� ezt Ã*rta:

>
> you need to have a macro for each button but the macros can call a
> common subroutine located in a module
>
> place in a vba sheet
>
> Private Sub CommandButton1_Click()
> Call Commonbutton(ActiveSheet)
> End Sub
>
>
> Place in a moudle
>
> Sub Commonbutton(Sht as Variant)
>
>
>
> end Sub
>
>
> --
> joel
> ------------------------------------------------------------------------
> joel's Profile: 229
> View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160217
>
> Microsoft Office Help
>
> .
>

Unfortunately it didn't work. If a sheet is in a window other than window 1,
buttons don't work at all, no macro is triggered. Pushing action is not
animated like in cases when the button works.
--
Regards!
Stefi



„Stefiâ€� ezt Ã*rta:

> Many thanks Joel, I'm going to try it.
>
> --
> Regards!
> Stefi
>
>
>
> „joelâ€� ezt Ã*rta:
>
> >
> > you need to have a macro for each button but the macros can call a
> > common subroutine located in a module
> >
> > place in a vba sheet
> >
> > Private Sub CommandButton1_Click()
> > Call Commonbutton(ActiveSheet)
> > End Sub
> >
> >
> > Place in a moudle
> >
> > Sub Commonbutton(Sht as Variant)
> >
> >
> >
> > end Sub
> >
> >
> > --
> > joel
> > ------------------------------------------------------------------------
> > joel's Profile: 229
> > View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160217
> >
> > Microsoft Office Help
> >
> > .
> >

I think it's an old bug that controls from the control toolbox toolbar won't
work when there are two windows into the same worksheet--the commandbutton in
the top window works, but the commandbutton in the bottom window doesn't (for
example).

Maybe you could replace the commandbuttons from the control toolbox toolbar with
buttons from the Forms toolbar.

(Or remove the window????)

Stefi wrote:
>
> Hi All,
>
> I I have more than one window of a workbook, buttons work only on window No.
> 1.
>
> Can it be achieved somehow that buttons work on other wondows, too?
>
> --
> Regards!
> Stefi

--

Dave Peterson

Thanks, Dave, two windows is an essential part of my present project, I'm
going to try Forms toolbar.

I use Excel2003, do you have any information on fixing this bug in Excel2007?

--
Regards!
Stefi



„Dave Petersonâ€� ezt Ã*rta:

> I think it's an old bug that controls from the control toolbox toolbar won't
> work when there are two windows into the same worksheet--the commandbutton in
> the top window works, but the commandbutton in the bottom window doesn't (for
> example).
>
> Maybe you could replace the commandbuttons from the control toolbox toolbar with
> buttons from the Forms toolbar.
>
> (Or remove the window????)
>
> Stefi wrote:
> >
> > Hi All,
> >
> > I I have more than one window of a workbook, buttons work only on window No.
> > 1.
> >
> > Can it be achieved somehow that buttons work on other wondows, too?
> >
> > --
> > Regards!
> > Stefi
>
> --
>
> Dave Peterson
> .
>

Thanks, Joel, I'm going to give it a try!
--
Regards!
Stefi



„joelâ€� ezt Ã*rta:

>
> Do you mean sheet 1? Select each button and right click. then select
> view code. Excel will automatically create the macro in the proper
> location. The button number is probably different.
>
> I usually change the Name in the button property to something revelent
> like RunAddition(). Then change the macro name of the click function to
> match the name property like Private Sub RunAddition_Click().
>
>
> --
> joel
> ------------------------------------------------------------------------
> joel's Profile: 229
> View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160217
>
> Microsoft Office Help
>
> .
>

On dec. 14, 10:50, Stefi <St...@discussions.microsoft.com> wrote:
> Thanks, Joel, I'm going to give it a try!
> --
> Regards!
> Stefi
>
> „joel” ezt írta:
>
>
>
>
>
> > Do you mean sheet 1? *Select each button and right click. *then select
> > view code. *Excel will automatically create the macro in the proper
> > location. *The button number is probably different.
>
> > I usually change the Name in the button property to something revelent
> > like RunAddition(). *Then change the macro name of the click functionto
> > match the name property like Private Sub RunAddition_Click().
>
> > --
> > joel
> > ------------------------------------------------------------------------
> > joel's Profile: 229
> > View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=160217
>
> > Microsoft Office Help
>
> > .- Idézett szöveg elrejtése -
>
> - Idézett szöveg megjelenítése -

I tried it, Joel, but it didn't help. It's interesting: If I have the
two windows already at design time then The new button works in the
second window until second window is not closed and opened again.
After re-opening a second window the button stops working in the
second window, it works only in the 1st window.
I couldn't find any other workaround than Dave's suggestion to use
Forms buttons (it works, thanks to Dave for it!).
Regards,
Stefi

I don't use xl2007 to know if the bug has been fixed in xl2007.

If you're looking for an answer, then maybe someone running xl2007 will chime
in.

If you've noticed that xl2007 still has the bug, then I don't know of any plans
to address the problem.

In fact, maybe someone running xl2010 will take the time to test it and report
back with their findings????



Stefi wrote:
>
> Thanks, Dave, two windows is an essential part of my present project, I'm
> going to try Forms toolbar.
>
> I use Excel2003, do you have any information on fixing this bug in Excel2007?
>
> --
> Regards!
> Stefi
>
> „Dave Petersonâ€� ezt Ã*rta:
>
> > I think it's an old bug that controls from the control toolbox toolbar won't
> > work when there are two windows into the same worksheet--the commandbutton in
> > the top window works, but the commandbutton in the bottom window doesn't (for
> > example).
> >
> > Maybe you could replace the commandbuttons from the control toolbox toolbar with
> > buttons from the Forms toolbar.
> >
> > (Or remove the window????)
> >
> > Stefi wrote:
> > >
> > > Hi All,
> > >
> > > I I have more than one window of a workbook, buttons work only on window No.
> > > 1.
> > >
> > > Can it be achieved somehow that buttons work on other wondows, too?
> > >
> > > --
> > > Regards!
> > > Stefi
> >
> > --
> >
> > Dave Peterson
> > .
> >

--

Dave Peterson

On dec. 14, 14:38, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> I don't use xl2007 to know if the bug has been fixed in xl2007.
>
> If you're looking for an answer, then maybe someone running xl2007 will chime
> in.
>
> If you've noticed that xl2007 still has the bug, then I don't know of anyplans
> to address the problem.
>
> In fact, maybe someone running xl2010 will take the time to test it and report
> back with their findings????
>
>
>
>
>
> Stefi wrote:
>
> > Thanks, Dave, two windows is an essential part of my present project, I'm
> > going to try Forms toolbar.
>
> > I use Excel2003, do you have any information on fixing this bug in Excel2007?
>
> > --
> > Regards!
> > Stefi
>
> > „Dave Peterson” ezt írta:
>
> > > I think it's an old bug that controls from the control toolbox toolbar won't
> > > work when there are two windows into the same worksheet--the commandbutton in
> > > the top window works, but the commandbutton in the bottom window doesn't (for
> > > example).
>
> > > Maybe you could replace the commandbuttons from the control toolbox toolbar with
> > > buttons from the Forms toolbar.
>
> > > (Or remove the window????)
>
> > > Stefi wrote:
>
> > > > Hi All,
>
> > > > I I have more than one window of a workbook, buttons work only on window No.
> > > > 1.
>
> > > > Can it be achieved somehow that buttons work on other wondows, too?
>
> > > > --
> > > > Regards!
> > > > Stefi
>
> > > --
>
> > > Dave Peterson
> > > .
>
> --
>
> Dave Peterson- Idézett szöveg elrejtése -
>
> - Idézett szöveg megjelenítése -

Thanks, Dave I'll wait for an answer from an XL2007 user. XL2010 is
far away yet.