View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
joel[_312_] joel[_312_] is offline
external usenet poster
 
Posts: 1
Default Buttons in another window


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