Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force Path for File Saving
Hi,
is there a way in Excel to force the file name and path - thus preventing the user from choosing his own under the file, save as drop down. I want to do this to prevent users on a shared workbook saving versions of the file...I want it to always save to the same file on the network thus preventing multiple copies. Thanks for your help....Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force Path for File Saving
Chris
You could put some Workbook_BeforeSave() event code in the ThisWorkbook module in your workbook. (To implement right click on the Excel icon at the top left of the workbook and select view code... Paste here) Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If SaveAsUI Then Cancel = True MsgBox "You cannot save this file to another location", _ vbOKOnly + vbInformation, "Error" End Sub If a user selects Save as... it will cancel the save and alert the user. This way they can only save to the original workbook. (They can take a copy of course) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Chris Gorham" wrote in message ... Hi, is there a way in Excel to force the file name and path - thus preventing the user from choosing his own under the file, save as drop down. I want to do this to prevent users on a shared workbook saving versions of the file...I want it to always save to the same file on the network thus preventing multiple copies. Thanks for your help....Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving txt file from excel by specifying path - drop down directory explorer | Excel Programming | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
How do I force a user to fill in all cells in excel before saving | Excel Discussion (Misc queries) | |||
Saving a file to a different path | Excel Programming | |||
Force *relative* path in Insert Hyperlink dialog | Excel Programming |