Limit available "Save as type" option in Windows "Browse" menu

Posted on 2014-04-03
Last Modified: 2014-04-03
Hello Experts:

In a previous post, I requested assistance with modifying VBA code for a .DOT template.   The URL for that post is:

Expert DrTribos provided an excellent solution which allowed bring up the Windows default "Browse" dialog box so that user can specify the file location and file name.

As part of a follow-up question though, I now need to determine the available menu options (for "Save as type:") can be limited.    That is, given the organization's environment (i.e., military), users are NOT allowed to store macros or macro-enabled document on their network.

So, here is my question:   Can the Windows Browse dialogue box be tweaked so that the
2nd option (see below) is NOT part of the options?

Word Document
Word Macro-Enabled Document
Word 97-2003 Document

Thank you,
Question by:ExpExchHelp
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 27

Assisted Solution

MacroShadow earned 100 total points
ID: 39975429
I don't think so.
LVL 15

Assisted Solution

DrTribos earned 300 total points
ID: 39975518
Off the back of your last Q. I've done a bunch of searching and don't think it is possible... even if you could do it I'm guessing it would involve either:

Registry hack, or

Reg had would only work on the target PC
VBA would only be effective if macros were enabled

Either way, there's not much out there to suggest it is possible.
LVL 15

Accepted Solution

achaldave earned 100 total points
ID: 39975632
You can use group policy to disable unsigned macros, this will not prevent them to save in the formats you want to block but at least it will prevent unsigned macros from loading, so any macro you are currently using needs to be signed first.

If they are allowed to save only to file server and file server is windows based you can use file server resource manager to block certain extensions.

To achieve exactly what you want to do, you need custom VBA (intercepting save event) as suggested by DrTribos.
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

LVL 15

Assisted Solution

DrTribos earned 300 total points
ID: 39975665
And... re-reading you question... we can rule out the VBA path due to violation of the main point of the question...

You can try to set a global policy to lockdown word so that macros do not run.  BUT I work as a technical writing trainer and half the places I visit have macros disabled for whatever reason and I always manage to enable them for the duration of the training ;-)

A Com addin might be the best bet... it is not a macro, can be written in C#.Net or VB.Net and could intercept the save as...
LVL 15

Assisted Solution

DrTribos earned 300 total points
ID: 39975669
However, it might be easy for a user to disable a com addin... so that pretty much means we have to focus on Registry???

Author Closing Comment

ID: 39975724
All -- thank you for your valuable feedback.    I'll discuss this topic w/ the team.  

Just to clarify... simply because a Word document was saved as a "Macro-enabled" document doesn't mean it's macro (or contains or macro code).

Can you validate the above statement?

LVL 15

Expert Comment

ID: 39975737
That is a true statement.  Macro enabled does not mean there is a macro inside.

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
XML error not understood 5 33
FTP recursive download files 5 28
How to create a Fillable Form in Adobe Acrobat Pro. 7 26
max value in vbscript 7 18
Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question