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

S

santhosh.natesh

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
 
H

Helmut Weber

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