Hi, can you change the colour of a command button that is inserted on
sheet not a form?

If it can be done, how?

Thanks Chri

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

Right-Click select properties and change the BackColor property to the color
you want

Charlie
"chrisdarl " wrote in message
...
Hi, can you change the colour of a command button that is inserted on a
sheet not a form?

If it can be done, how?

Thanks Chris


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

As long as it is a toolbox control, not a form control.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Charles May" wrote in message
news:nWxnc.15071$z06.2539009@attbi_s01...
Right-Click select properties and change the BackColor property to the
color
you want

Charlie
"chrisdarl " wrote in message
...
Hi, can you change the colour of a command button that is inserted on a
sheet not a form?

If it can be done, how?

Thanks Chris


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

Hi, i have a command button on a sheet, this was inserted using the for
toolbar, it is not in a form or anything. i am wanting to change th
back colour of the button, can this be done in VBA?

Thanks Chris

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

No, and it can't even be done without VBA :-).

--

Vasant

"chrisdarl " wrote in message
...
Hi, i have a command button on a sheet, this was inserted using the form
toolbar, it is not in a form or anything. i am wanting to change the
back colour of the button, can this be done in VBA?

Thanks Chris.


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