Thread: Stored code
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
N10 N10 is offline
external usenet poster
 
Posts: 141
Default Stored code

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/