Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
prevent location change before saving
Albert,
You can use the _BeforeSave event to control how/where users save the file. And if they are trying to SaveAs by checking the SaveAsUI value. It everything is not OK, set Cancel=True. However, if the user disables macros or events, this will not work. And if they merely copy/move from windows, there is obviously nothing Excel can do. NickHK "Albert" wrote in message ... Hi. I have a network on which several people work. I am a little bit worried about information leakage, and I would like to know if there is a way of preventing people from saving the networked workbooks to a location different from the one I can supervise. Is this possible? Best regards, Albert C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent Saving | Excel Discussion (Misc queries) | |||
Prevent Saving From Web | Excel Programming | |||
Want to prevent users from changing location of shape textboxes | Excel Programming | |||
How do I change the default location when saving Email attachment | Excel Discussion (Misc queries) | |||
Saving in a location | Excel Programming |