VBA Hide Developer Tab

[Jules]

Wish to hide Developer Tab and make it inaccessible. As my VBA
locks/disables editing of ContentControls after templates have run but of
course users can just go to developer tab? Any ideas on best way to do this?
I don't want to turn on protection it is useless. I really just want to
make sure the DEVELOPER tab is not able to be made available except via a
password toggle maybe?
Any ideas please?

Thank you.

 

[Cindy M.]

Hi Jules,

Wish to hide Developer Tab and make it inaccessible. As my VBA
locks/disables editing of ContentControls after templates have run but of
course users can just go to developer tab? Any ideas on best way to do this?
I don't want to turn on protection it is useless. I really just want to
make sure the DEVELOPER tab is not able to be made available except via a
password toggle maybe?

I think the only way you can do this would be to define a Ribbon in your
templates that explicitly hides the Developer tab (in documents created from
the template, only).

There's a 3-part article that explains how to customize the RibbonXML at
http://msdn.microsoft.com/en-us/office/aa905530.aspx

How to create a Ribbon for a document is explained in Part 1. You can
"streamline" incorporating the Ribbon XML in your document by using the Custom
UI Editor, a free tool that can be downloaded at
http://openxmldeveloper.org/articles/CustomUIeditor.aspx

Here's the Ribbon XML to make the Developer tab invisible:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="false">
<tabs>
<tab idMso="TabDeveloper" visible ="false" />
</tabs>
</ribbon>
</customUI>

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Jules]

Is that the only way Cindy (disappointing!) - I don't want to redefine the
base ribbon users are entitled to do as they wish with that they all work
differently.
I've added my own Add-in to the Ribbon - I just wanted to control with VBA
users accessing the developer tab (not too easily) after the datafill takes
place - always a catch!
Yes I have all the XML Ribbon info but thank you Cindy.

 

[Cindy M.]

Hi Jules,

Is that the only way Cindy (disappointing!) - I don't want to redefine the
base ribbon users are entitled to do as they wish with that they all work
differently.
I've added my own Add-in to the Ribbon - I just wanted to control with VBA
users accessing the developer tab (not too easily) after the datafill takes
place - always a catch!

Take a closer look at my suggestion and the XML: you're not redefining the
base ribbon. All you'd be doing is setting the Visible property of the
Developer tab so that it won't display. And that only in the documents based
on this template. That's what you wanted, isn't it ("Wish to hide Developer
Tab and make it inaccessible.")?

If you changed the setting in Word Options, via the object model, that would
affect all documents, not just those attached to your template. And you'd have
no way to keep it turned off.

If it's only certain buttons or groups you want disabled in the Developer tab
you can do that too, in a similar way. It's also possible to disable single
built-in commands (again, just for the template and its documents) via the
Ribbon.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Jules]

Okay

Hi Jules,

Take a closer look at my suggestion and the XML: you're not redefining the
base ribbon. All you'd be doing is setting the Visible property of the
Developer tab so that it won't display. And that only in the documents
based
on this template. That's what you wanted, isn't it ("Wish to hide
Developer
Tab and make it inaccessible.")?

If you changed the setting in Word Options, via the object model, that
would
affect all documents, not just those attached to your template. And you'd
have
no way to keep it turned off.

If it's only certain buttons or groups you want disabled in the Developer
tab
you can do that too, in a similar way. It's also possible to disable
single
built-in commands (again, just for the template and its documents) via the
Ribbon.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)


This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail