Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Stoping users from saving tables to their local machines...
My question relates to server residing tables being saved locally.
While a write protected table cannot be altered on the server by a user (Without write rights) I am wondering if there is a way (Perhaps through Excel macros?) to stop a user from being able to save a given table to his local machine. Thanking all in adv. for your time, and I look forward to your replie(s). |
#2
|
|||
|
|||
hi.
your info is a little sketchy. because you posted in excel, i'm assuming that your tables are in an excel file. i don't know how may users you have but you might try something like this..... Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If Application.UserName = "DoeJohn" Then MsgBox ("you are not authorized to save this file.") Cancel = True 'cancels the save ActiveWorkbook.Close False 'false = not saved. End If End Sub this would prevent a user named DoeJohn from saving the file but would allow others to save the file meaning you may have to do it surgically. if you only want yourself to save then you might want to modify the if statement..... if application.username <"yourname" then this may not be what you have in mind but maybe it will give you ideas. Regards FSt1 "Philippe Roy" wrote: My question relates to server residing tables being saved locally. While a write protected table cannot be altered on the server by a user (Without write rights) I am wondering if there is a way (Perhaps through Excel macros?) to stop a user from being able to save a given table to his local machine. Thanking all in adv. for your time, and I look forward to your replie(s). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preventing other users saving another version of protected workboo | Excel Discussion (Misc queries) | |||
Preventing users from saving a spreadsheet | Excel Discussion (Misc queries) | |||
Stoping users pasting formulas into cells | Excel Worksheet Functions | |||
How do I keep other users from saving my read-only document? | Excel Discussion (Misc queries) | |||
Saving Excel ranges as database tables | Excel Discussion (Misc queries) |