View Full Version : Disable design mode with password?

11-30-2007, 09:56 AM
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?

12-01-2007, 02:10 AM

12-01-2007, 03:28 AM
I have no idea what you mean, can you explain further ?

12-02-2007, 05:07 AM
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?

12-02-2007, 05:59 AM
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

12-02-2007, 11:05 AM
Hi xld!

what does dummyproc do?

12-02-2007, 11:37 AM
Nothing. That's the idea.