Disabling Styles and Formatting

N

Nick Miller

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

tjtjjtjt

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
 
Top