Disable design mode with password?

[andrewvanmar]

Trying to close the last "holes" in my document i found that even though I lock sheets and the VBA users still have access to the design mode button. Is there a way to disable it behind a password?

[jammer6_9]

.

[unmarkedhelicopter]

I have no idea what you mean, can you explain further ?

[andrewvanmar]

There is this button called design mode, it disables all scripts. ( looks like a ruler a protractor and other math tool)

While everything else is locked in the document, the users are still able to access this button and turn off some crucial scripts.

is there a way to turn off this tool, while allowing -me- through a password to access it?

[Bob Phillips]

Perhaps disable it



Public Sub DisableDesignMode()
Dim ctl As CommandBarControl

Set ctl = Application.CommandBars.FindControl(ID:=1605)
ctl.OnAction = "DummyProc"

End Sub

Private Sub DummyProc()

End Sub

[andrewvanmar]

Hi xld!

what does dummyproc do?

[Bob Phillips]

Nothing. That's the idea.