ExcelBanter - disable users from editing an excel sheet once they open

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - disable users from editing an excel sheet once they open (https://www.excelbanter.com/excel-discussion-misc-queries/160171-disable-users-editing-excel-sheet-once-they-open.html)

Pietro

disable users from editing an excel sheet once they open

Hi,

I want to disable users from editing an excel sheet once they open
it,then,on closing the sheet,it becomes editable again,while closed.
The reason is that i want to put all the data in this sheet through an
access database,and disable users from editing it...

All times are GMT +1. The time now is 05:59 AM.