View Single Post
  #2   Report Post  
FSt1
 
Posts: n/a
Default

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).