Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test User before saving a file.
What I want to do is put code in the ThisWorkbook...Before Save. My
ultimate goal is to test the user and not allow other users to save the file. I need for others to view the file but I dont want them to be able to save it. Also, I dont want to password the file because then I have to input a password every time. Is there a way to in Before Save say something like: ReturnNetworkName = Environ("UserName") If ReturnNetworkName = "TheCorrectID" Then ...allow save Else MsgBox "You are not the authorized user to save this file." Endif Thank you for your help. Steven |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test User before saving a file.
Before save has a cancel argument. Use the code you have and set the cancel
argument as is appropriate. You will probably want to use a function to determine if the username is in your list of allowable user names... -- HTH... Jim Thomlinson "Steven" wrote: What I want to do is put code in the ThisWorkbook...Before Save. My ultimate goal is to test the user and not allow other users to save the file. I need for others to view the file but I dont want them to be able to save it. Also, I dont want to password the file because then I have to input a password every time. Is there a way to in Before Save say something like: ReturnNetworkName = Environ("UserName") If ReturnNetworkName = "TheCorrectID" Then ...allow save Else MsgBox "You are not the authorized user to save this file." Endif Thank you for your help. Steven |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared excel (2000) file not saving for one user | Excel Discussion (Misc queries) | |||
saving the last user who edited the file | Excel Discussion (Misc queries) | |||
Test for file path, alert user and close workbook | Excel Programming | |||
Saving a file from a command button with user input | Excel Programming | |||
prevent user from saving excel file to a folder | Excel Programming |