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

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

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

.

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

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 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 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

.- 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