Buttons in another window

  • Thread starter Thread starter Stefi
  • Start date Start date
S

Stefi

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?
 
Many thanks Joel, I'm going to try it.

--
Regards!
Stefi



„joel†ezt írta:
 
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/showthread.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????)
 
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????)
 
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().
.- 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????


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




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?
„Dave Peterson” ezt írta:

--

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