Disabling or hiding Tools/Macro/Visual Basic Editor option

[bz]

In the documents based on my template, I want to disable or hide the Visual
Basic Editor option so the user can't view the macros. I tried
Application.ShowVisualBasicEditor = False (in the New event), but it didn't
work. I'd very much appreciate any advice on how to do this.

 

[Doug Robbins - Word MVP]

You need to open the template and with it selected in the Visual Basic
Editor, go to the Tools menu of the Editor and select the [TemplateName]
Properties item and in the [TemplateName] - Project Properties dialog, go to
the Protection tab and check the box for "Lock project for viewing" and then
enter a password. DO NOT FORGET the password.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[bz]

Thanks very much, this is what I needed!

You need to open the template and with it selected in the Visual Basic
Editor, go to the Tools menu of the Editor and select the [TemplateName]
Properties item and in the [TemplateName] - Project Properties dialog, go to
the Protection tab and check the box for "Lock project for viewing" and then
enter a password. DO NOT FORGET the password.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

In the documents based on my template, I want to disable or hide the
Visual
Basic Editor option so the user can't view the macros. I tried
Application.ShowVisualBasicEditor = False (in the New event), but it
didn't
work. I'd very much appreciate any advice on how to do this.