Disabling font color button

M

Michael Singmin

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
 
R

Ron de Bruin

Your sheet is protect Michael

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
Match table shading (color) to Visio color/Transparency 1
WORD VBA Search and switch to advanced ... 1
Font color button 10
condition for run macro 2
Command button icons when disabled 1
Form hides control buttons 0
Changing the text color on a commandbar button 0

Top