Hello,
Could someone let me know if it possible to set an excel spreadsheet to have 'write access' for myself, but 'read only' access for other people, unless they enter a password to be able to edit?
Many thanks
Hello,
Could someone let me know if it possible to set an excel spreadsheet to have 'write access' for myself, but 'read only' access for other people, unless they enter a password to be able to edit?
Many thanks
Hi,
Yes,
When you next save the workbook use the 'Save As' option, in the 'Tools' drop down select 'General Options', set a password in the 'Modify' box and tick the 'Read Only' option
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks