View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sharad Naik Sharad Naik is offline
external usenet poster
 
Posts: 212
Default Command Button's 'back color'

So it appears the the command button is in worksheet and not in user form.

Let's say the command button is 'CommandButton5'

The code can simply be
Sheet1.CommandButton5.BackColor = RGB (255,0,0)

Sharad
"Paul" wrote in message
...
Hi,

How do I change a Command Button's 'back color' in code from a Toolbar
Form
in an Excel Worksheet?

Thanks
Paul