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?
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?
.
T-ogether
E-veryone
A-chieves
M-ore
One who asks a question is a fool for five minutes; one who does not ask a question remains a fool forever.
I have no idea what you mean, can you explain further ?
2+2=9 ... (My Arithmetic Is Mental)
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?
Perhaps disable it
[vba]
Public Sub DisableDesignMode()
Dim ctl As CommandBarControl
Set ctl = Application.CommandBars.FindControl(ID:=1605)
ctl.OnAction = "DummyProc"
End Sub
Private Sub DummyProc()
End Sub
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Hi xld!
what does dummyproc do?
Nothing. That's the idea.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber