Printable View
Hi folks,
I am not too great with VBA, but i came across this usefull utility and i want to open it to see its inner workings, but the button seems to be embedded into the sheet and i cant use VB editor to move or see what sub routine it kicks off...
Any ideas?
Cheers
You can view the module code by pressing Alt+F11 to bring up the VBA IDE. This workbook is not protexted or anything.
yeah but i cant see the code behind the buttons and i cant move the button?
To move the button, right click on it to select it, then left click on it to get rid of the popup menu, then left click the edges and you can drag-n-drop it. To see the code, right click on the button, select "Assign Macro" from the dropdown menu, this wil bring up an "Assign Macro" dialog, the assigned macro name will appear in the "Macro Name" box. Go to the VBA editor and find the macro name for the code. :)Quote:
Originally Posted by dinosaur_uk
Cheers! Sorted!