Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to make an xls file allow only one user access at a time.
I have an xls file that I want to lock down and only allow one user at a time
access... I do not even want people to be able to go in with readonly.... Thanks |
#2
|
|||
|
|||
How about closing the workbook if it's opened readonly--and this'll only work if
macros are enabled! Option Explicit Sub auto_open() With ThisWorkbook If .ReadOnly = True Then MsgBox "not available in readonly mode!" .Close savechanges:=False End If End With End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm garyxprice wrote: I have an xls file that I want to lock down and only allow one user at a time access... I do not even want people to be able to go in with readonly.... Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot access a file -- HELP | Excel Discussion (Misc queries) | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
Importing Access File with Hyperlink | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
Network access to file - read only property | Excel Discussion (Misc queries) |