Dear Friends,

every time we add a button or any other interface component on an Exce
worksheet, where is the corresponding VBA code located and saved?

Thanks,
G

--
Message posted from http://www.ExcelForum.com

HI

Right click the button in after selecting design mode.

Then select view code from the list. This will open the VB editor and
provide the oppurtunity to either view existsing code for that button or
create a new sub routine for the button button.

Buttons are a mans best freind :)

N10



"banavas " wrote in message
...
Dear Friends,

every time we add a button or any other interface component on an Excel
worksheet, where is the corresponding VBA code located and saved?

Thanks,
G.


---
Message posted from http://www.ExcelForum.com/