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