Word VBA: deployment

S

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.
 
J

Jonathan West

sharon3874 said:
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?

You can't.
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?

He can.
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.

Take a step back. Overall, what are you trying to achieve here?
 
S

sharon3874

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.
 
J

Jonathan West

sharon3874 said:
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.

I don't think you can prevent design mode. Therefore you need to try nd get
your menu to work right even if the user goes into design mode and back
again. What stops working?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top