I am using Office 2002 and wnat to lock my toolbars in place. Is there a way that anybody knows to do that. I will except just locking Word if that is possible but would like to lock them all globally if possible.
You can run this code from a workbook / document's Open event:
Code:
Sub LockDown()
Dim cmdBar As CommandBar
For Each cmdBar In Application.CommandBars
If cmdBar.Visible = True Then
'(I don't think it can be changed unless visible)
cmdBar.Protection = msoBarNoMove or msoBarNoChangeVisible
End If
Next
End Sub
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.