Single User/Read-Only Macro

[DanA1509]

Hi there,

I am looking for help in creating a macro that restricts access to a workbook to a single user to have editing privileges when first opened, and any subsequent person opening that document to have read-only access.

The document is a job booking system that allows people to write basic information that feeds into the spreadsheet document so I don't want two people booking the job using the same code. I have a time-out macro written into the document as well that will shut down the original document if unused for 5 minutes.

Although I am an old hand with general excel I'm not very clued up with macros so please bear with me when trying to explain things.

Thank you for your help,
Dan</SPAN>

 

[Jaafar Tribak]

While a normal (non-shared) workbook is open, only the first user has editing privileges ...That's the default behaviour.

 

[DanA1509]

Well that wsa a lot simpler than I thought, however is there a way to limit people creating a local copy and updating on that? Or is this just fanciful thinking?