Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-15-2013, 02:09 AM
la_gillespie25 la_gillespie25 is offline ON ENTRY Command Windows 7 64bit ON ENTRY Command Office 2007
Novice
ON ENTRY Command
 
Join Date: May 2013
Location: Derry, Northern Ireland
Posts: 7
la_gillespie25 is on a distinguished road
Default ON ENTRY Command

I want to create an on entry command for a specific document - i want it so when the document is opened, i want it to automatically force the user to save as.



How can you do this?
Reply With Quote
  #2  
Old 05-15-2013, 02:18 AM
macropod's Avatar
macropod macropod is offline ON ENTRY Command Windows 7 32bit ON ENTRY Command Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

It's impossible to 'force' a user to do anything - they could always disable the macro or, even if they let it run, it's difficult preventing them cancelling out of the dialogue or forcing the macro to crash. Depending on what you're doing, you could, however, encode the macro to do its own 'Save As' without user involvement. See, for example: http://www.techsupportforum.com/foru...er-694900.html

In any event, from your description it seems you should be using a template, not document. Double-clicking on a template creates a new document that can only be saved via Save As.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
ON ENTRY Command Drop-down Populated with text entry ReviTULize Word VBA 14 02-21-2013 07:06 PM
ON ENTRY Command Hyperlink to specific TOC entry sidbiffel Word 1 07-06-2012 05:25 PM
Printable Entry Form eJames Excel 1 01-07-2010 09:50 AM
Add-In:How to add command right click command bar phang Outlook 0 01-15-2007 02:53 AM
Entry point not found? Zanmax Outlook 0 02-14-2006 06:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft