Excel: Font colour for whole worksheet

[SimonFinn]

Hi

Is there a method of changing the font colour of the whole worksheet to black using VBA?

Thanks Si

 

[xlbo]

sheets("Sheetname&quot.cells.font.colorindex = 1

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[SimonFinn]

Thanks Geoff,

Could i ask another question: how can i disable a command button from a module?

Thanks Si

 

[xlbo]

Depends what you mean by disable, what kinda button (Forms or Controls menu) and where the button is (sheet or userform)



Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[Loomah]

Hi
an example would be

CommandBars("standard").Controls("Save").Enabled = False / True

;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[SimonFinn]

Thanks for the help, both solutions worked a treat!!

Cheers Si