button

B

BINZA@

I have a button which is on a page in excel workbook which has a title of
get data, when it is pressed it refreshes the data on the page.
What i would like to know is how can i see the commands behind the button.
any help much appreciated.
 
N

Nick Hodge

Binza

If the project isn't locked you can right click on the button. If it is a
'Forms' button, you can select the Assign Macro Button to see which one is
assigned, if it is an activeX control button, then right click and select
'View code' this will open the VBE with the event code in the window

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html
 
G

Gary''s Student

For a Forms button:

1. Right-click the button
2. Assign Macro...
3. Edit
 
Top