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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference must be to a macro sheet? 1
Help changing the sheet name 3
Command Button- Assign Macro & Sheet Protection problem 1
how to make macro work even a sheet is hidden. 3
How do I clear a form? 0
How to change QAT button image in VBA? 1
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
Assign a macro to the save button 4

Top