View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] HammerJoe@gmail.com is offline
external usenet poster
 
Posts: 126
Default How to set up caption on a button at startup?

Hi,

I have a small spreadsheet with a command button called makebusy.
I also have a macro called Auto_open to automatically run whenever the
worksheet is open.
What I would like to have is that at startup (somehwere in the
auto_open sub) to set up the caption of my button to "start".

The reason is that when the button is clicked I change the caption of
it, and I would like it to start by daefault as "start" whenever the
sheet is opened.

Any help would be appreciated.
Thanks