Here’s one that I think is simple, but I can’t find a way to do it.
I have a MS Word 2000 document that is filled out partially by macros, and the user inserts the rest manually. Is there a way to prevent the user from clicking on the ‘Save’ icon, and forcing them to always use the ‘Save As’? Is it just a matter of making it a template, or is there more to it than that?
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Disabling SAVE, allowing SAVEAS (VBA )
Home » Forums » AskWoody support » Productivity software by function » Visual Basic for Applications » Disabling SAVE, allowing SAVEAS (VBA )
- This topic has 10 replies, 6 voices, and was last updated 22 years, 9 months ago.
AuthorTopicWSBriana
AskWoody LoungerAugust 22, 2002 at 2:07 pm #375370Viewing 4 reply threadsAuthorReplies-
WScarbonnb
AskWoody LoungerAugust 22, 2002 at 2:16 pm #610709Well if there are already macros in the document, you can add this macro to the doc:
Sub FileSave() With Application.Dialogs(wdDialogFileSaveAs) .Display .Execute End With End Sub
This will “hijack” the File|Save menu item, the CTRL+S and the Save Menu button and always display the SaveAs dialog.
-
WSHansV
AskWoody LoungerAugust 22, 2002 at 2:18 pm #610711The easiest way is to save the document as a template, and put it in one of the template folders. If your users are on a network, you can create a network forlder, put the template there, and have users point their Workgroup Templates path (in Tools/Options…, File Locations tab) to this folder. They will see the template when they select File/New…
An alternative – but more complicated – is to create a macro that replaces the File/Save command:
Sub FileSave()
With Dialogs(wdDialogFileSaveAs)
Select Case .Display
Case 0 ‘ Cancel
‘ No need to do anything on Cancel
‘ Unless you want to display a message
Case -1 ‘ OK
‘ Whatever you want to do on OK, for instance
.Execute
End Select
End With
End Sub -
WSKlaus Linke
AskWoody LoungerSeptember 6, 2002 at 8:00 pm #614751I think it has been said that making the document a template is the way to go?
If you intercept “Save”, you may need/want to also intercept/redirect other commands to SaveAs:
FileClose, FileCloseAll, FileCloseOrCloseAll, FileCloseOrExit, FileExit, FileSaveAll, FileSaveAsWebPage, FileSaveFrameAs, FileSaveHtml, FileSaveVersion
(the Close commands because if you made changes, you will be asked if you want to save).A bit nasty are the CloseAll/SaveAll commands, which may run endlessly until all documents are closed/saved unless intercepted properly. But many users won’t know about them anyhow (they appear on the File menu if you hold the Shift key).
BTW, I haven’t found what Command is run if you click on the close button (
-
WScarbonnb
AskWoody Lounger -
WSKlaus Linke
AskWoody Lounger -
WScarbonnb
AskWoody LoungerSeptember 7, 2002 at 11:13 am #614882There is a Document Close button in the first Word Window only.
I have two main reference for Word’s commands.
- Woody’s – Word 97 Annoyances
- the macros dialog box (Tools|Macros|Macros… Change Macros In: to Word Commands)
Sprinkled with a generous helping of trial and error
I haven’t tried intercepting the Help commands, until just now, and I can’t seem to get them to work either.
I hadn’t heard of that template, but it looks interesting. I just downloaded it.
-
WSKlaus Linke
AskWoody Lounger
-
-
-
-
-
WSBriana
AskWoody Lounger -
WSjscher2000
AskWoody LoungerAugust 22, 2002 at 6:40 pm #610821As a footnote to these two posts, a template is much better than a document because it creates a fresh document. Forcing a SaveAs, the user could easily “replace” the document despite having to do it the hard(er) way, by choosing the same name and path (unless you trap for that…complicating your macro). If you need it to be a document rather than a template, making the document read-only in the file system would protect it more simply than a macro, but of course, anyone with privileges to change that setting could do it if they wanted to badly enough.
-
WSaichkay
AskWoody LoungerSeptember 6, 2002 at 5:19 pm #614720
Viewing 4 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
AMD : Out of Bounds (OOB) read vulnerability in TPM 2.0 CVE-2025-2884
by
Alex5723
8 hours, 19 minutes ago -
Totally remove or disable BitLocker
by
CWBillow
7 hours, 13 minutes ago -
Windows 10 gets 6 years of ESU?
by
n0ads
4 hours, 2 minutes ago -
Apple, Google stores still offer China-based VPNs, report says
by
Nibbled To Death By Ducks
19 hours, 6 minutes ago -
Search Forums only bring up my posts?
by
Deo
19 hours, 19 minutes ago -
Windows Spotlight broken on Enterprise and Pro for Workstations?
by
steeviebops
1 day, 6 hours ago -
Denmark wants to dump Microsoft for Linux + LibreOffice
by
Alex5723
23 hours, 25 minutes ago -
How to get Microsoft Defender to honor Group Policy Setting
by
Ralph
1 day, 7 hours ago -
Apple : Paragon’s iOS Mercenary Spyware Finds Journalists Target
by
Alex5723
1 day, 17 hours ago -
Music : The Rose Room – It’s Been A Long, Long Time album
by
Alex5723
1 day, 18 hours ago -
Disengage Bitlocker
by
CWBillow
1 day, 8 hours ago -
Mac Mini M2 Service Program for No Power Issue
by
Alex5723
1 day, 20 hours ago -
New Win 11 Pro Geekom Setup questions
by
Deo
19 hours, 15 minutes ago -
Windows 11 Insider Preview build 26200.5651 released to DEV
by
joep517
2 days, 3 hours ago -
Windows 11 Insider Preview build 26120.4441 (24H2) released to BETA
by
joep517
2 days, 3 hours ago -
iOS 26,, MacOS 26 : Create your own AI chatbot
by
Alex5723
2 days, 7 hours ago -
New PC transfer program recommendations?
by
DaveBoston
12 hours, 45 minutes ago -
Windows 11 Insider Preview Build 22631.5545 (23H2) released to Release Preview
by
joep517
2 days, 11 hours ago -
Windows 10 Build 19045.6029 (22H2) to Release Preview Channel
by
joep517
2 days, 11 hours ago -
Best tools for upgrading a Windows 10 to an 11
by
Susan Bradley
2 days ago -
The end of Windows 10 is approaching, consider Linux and LibreOffice
by
Alex5723
1 day, 4 hours ago -
Extended Windows Built-in Disk Cleanup Utility
by
bbearren
1 day, 13 hours ago -
Win 11 24H2 June 2025 Update breaks WIFI
by
dportenlanger
3 days, 6 hours ago -
Update from WinPro 10 v. 1511 on T460p?
by
CatoRenasci
2 days, 4 hours ago -
System Restore and Updates Paused
by
veteran
3 days, 9 hours ago -
Windows 10/11 clock app
by
Kathy Stevens
2 days, 20 hours ago -
Turn off right-click draw
by
Charles Billow
3 days, 12 hours ago -
Introducing ChromeOS M137 to The Stable Channel
by
Alex5723
3 days, 16 hours ago -
Brian Wilson (The Beach Boys) R.I.P
by
Alex5723
4 hours, 36 minutes ago -
Master patch listing for June 10, 2025
by
Susan Bradley
3 days, 17 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.