Reply to thread

Message

[QUOTE="CyberTaz, post: 6812264"]
Hey Scott;

You evidently put the wrong control on the toolbar :-) You used the Style...
tool which just opens the Style dialog -- the one you want is directly
beneath that one & displays as Style:[followed by a combo box]. You can drag
it to a new toolbar or add it to an existing bar.

As for the other button ideas, not without VBA. If 2008 supported VBA you
could create a macro to apply each Style & assign each macro to a custom
button. It may be possible to do something similar with Apple Script, but
that's out of my realm.

Styles aren't *sheet* specific but they are *workbook* specific. If you want
Styles from one book available in another use the Merge button in the Style
dialog to import from other books. You can also create a Workbook template
file containing your Styles so that each book generated from the template
would have the Styles available... Or save all your Styles in one specific
file & import as needed to other books.

Regards |:>)
Bob Jones
[MVP] Office:Mac
[/QUOTE]

Verification