General discussion


Lock the save location - Excel

By brian.wells ·
I have a database that a general query is saved in excel. I want to restrict the users from saving the spreadsheet anywhere but the f:\spreadsheets folder. They still need read/write access to the rest of the system so limiting user rights won't work. How can I do this?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by PramodPatil In reply to Lock the save location - ...

Changing Default Save Location

1. Click the Tools menu and select "Options...".

2. Click the "General" tab.

3. Change the "Default file location:" text to the path of the folder you want to set as the default save location.

4. Click OK.

Collapse -

by DKlippert In reply to Lock the save location - ...

Of course a dedicated user can do all kinds of things, but try this:

In the ThisWorkbook code section type:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
if SaveAsUI then
Cancel = TRUE
end if
End Sub

Related Discussions

Related Forums