Solved

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

Posted on 2014-04-03
7
359 Views
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:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Word/Q_28402631.html#a39974984

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,
EEH
0
Comment
Question by:ExpExchHelp
7 Comments
 
LVL 26

Assisted Solution

by:MacroShadow
MacroShadow earned 100 total points
Comment Utility
I don't think so.
0
 
LVL 14

Assisted Solution

by:DrTribos
DrTribos earned 300 total points
Comment Utility
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
VBA

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.
0
 
LVL 15

Accepted Solution

by:
achaldave earned 100 total points
Comment Utility
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.

http://technet.microsoft.com/en-us/library/gg490630(v=office.14).aspx

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.

http://blogs.technet.com/b/josebda/archive/2008/08/20/the-basics-of-windows-server-2008-fsrm-file-server-resource-manager.aspx

To achieve exactly what you want to do, you need custom VBA (intercepting save event) as suggested by DrTribos.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 14

Assisted Solution

by:DrTribos
DrTribos earned 300 total points
Comment Utility
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...
0
 
LVL 14

Assisted Solution

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

Author Closing Comment

by:ExpExchHelp
Comment Utility
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?

Thx,
EEH
0
 
LVL 14

Expert Comment

by:DrTribos
Comment Utility
That is a true statement.  Macro enabled does not mean there is a macro inside.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

762 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now