ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disabling font color button (https://www.excelbanter.com/excel-programming/277210-disabling-font-color-button.html)

Michael Singmin

Disabling font color button
 
Hello Group,

I have seen a Excel Worksheet where clicking on the font color button
on the toolbar does nothing.

I know know to set Enabled to False and I know how to set Visible to
False. So how does one disable the button without changing its
appearance ?

Thanks,

MIchael Singmin


Ron de Bruin

Disabling font color button
 
Your sheet is protect Michael

In 2002/2003 there is a option to change the format
when you protect your sheet

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Michael Singmin" wrote in message ...
Hello Group,

I have seen a Excel Worksheet where clicking on the font color button
on the toolbar does nothing.

I know know to set Enabled to False and I know how to set Visible to
False. So how does one disable the button without changing its
appearance ?

Thanks,

MIchael Singmin





All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com