Thread: Command Button
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Command Button

You need to be in "Design Mode" which is set via icon on the Visual Basic
Toolbar. (View=Toolbars=Visual Basic)
HTH

"Freshman" wrote:

Dear experts,

I've a command button on a worksheet. When clicked, an user form will show
up. However, when I want to change the caption on the command button by right
clicking it, it didn't response to show a short cut menu. So, I cannot change
the caption. I checked some information on internet, they also stated the
same method by right click to get a menu then choose Properties.... Anyway, I
cannot make it. Is there something wrong with the button? How to correct it
so that I can change the caption. Please kindly advise.

Thanks in advance.