Word VBA: deployment

[sharon3874]

I am new in VBA. I am sorry in advance if my question doesn't make sense.

I have a document with a button triggering a macro. I am just wondering how I deliver it to my users. I don't want my users to see the macro code, which I have already handled it with password protection.

My question is how I can prevent them from even switching to the design mode? Right now I can switch to the design mode by clicking View --> Toolbars --> Control Toolbox. I believe the user can do the same thing, right? So I am wondering normally how do you deploy a word doc with macro? Is there a special deployment process, or should I just write another macro(or any other way) to disable the "Control Toolbox" choice? If I need to disable the choice, how?

I will be really appreciated if you can advice. Thanks.

 

[Shawn12]

DO you only want them to see the end result?

 

[sharon3874]

Thank you for your reply.

Actually, I want them to see the document, and also modify the document.

I have customized the shortcut menu(right-click menu) on hyperlinks(add and delete menu items during runtime). I am asking the question because if I switch to the design mode, and exit the design mode, the menu doesn't work properly. If I don't switch to the design mode ever, it works fine. Thus I am trying to prevent them from switching to the design mode.

 

[fumei]

The real bottom line is: if you have clever users, you can't really prevent them from doing anything. You CAN disable the toggle by rewriting the Word command for it. Obviously you would want the rewrite to check to see if it is YOU who are trying to toggle. This checks the login name, if it is NOT you it displays a message; it is IS you it performs the toggle.

Sub ToggleFormsDesign()
  If Environ("username") <> "[i]your login name[/i]" Then
     Msgbox "Sorry, but Design Mode is not available."
  Else
     ActiveDocument.ToggleFormsDesign
  End If
End Sub

But again, you can password protect all you want, rewrite stuff all you want...but Word is never going to be made secure against someone who really knows what they are doing.

Gerry
My paintings and sculpture

 

[Shawn12]

fumei couldnt have said it better.