button

  • Thread starter Thread starter BINZA@
  • Start date Start date
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.
 
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
(e-mail address removed)
web: www.nickhodge.co.uk

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