How do i asssign a macro to a button in a different sheet

How do i asssign a macro to a button in a different sheet

Post by santhosh.n » Fri, 21 Jul 2006 01:16:24


Hello Guys

Obviously i am new to macro programming. This is my case. I have
recorded a macro in let us say sheet2. (It picks up values from a
default folder). I now want to assign this macro to a button, which is
in sheet1.

The actual assigning is not the problem, but the update is done on
sheet 1 itself. How do i tweak this so that when the button is clicked
sheet 2 is updated.

Can someone help please

Thanks
sanj
 
 
 

How do i asssign a macro to a button in a different sheet

Post by Helmut Web » Fri, 21 Jul 2006 04:00:25

Hi Sanj,

wrong group.

See: microsoft.public.excel.programming

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"