Disabling Styles and Formatting

[Guest]

Is there a way using VBA to create a macro that will disable the Styles an
Formating toolbar and button to access it.

 

[Guest]

This macro will do it:

Sub DisableFormattingToolbar()

CommandBars("Formatting").Enabled = False

End Sub

You may have to set it to happen when the workbook opens, if you want this
to happen when a user opens the book.

tj