Hi,
Is there a way where i can share my workbook on a shared drive with other users but prevent them from making changes to it and saving it. I want them to edit, sort, delete etc. but once they close the workbook they should not be able to save these changes. Thanks
Open visual basic
Open the ThisWorkbook Macro Module
Paste this code into the module and close it.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks for your response. I inserted the code into the macro of the workbook but when I make changes and click save its giving me an option to bypass it and save the workbook as a macro free book. Attached is a screen shot of what I am seeing.
Go to 'Save As' then click the 'Tools' button then the 'General Options' button.
You will get an option to enter a password to open and/or a password to modify.
Enter a password to modify and anyone who doesn't have this password will only be able to open the file as read-only. This will allow them to edit/delete/sort etc but not to save the file.
Note that this doesn't stop users saving a copy of the file with the changes.
(The instructions above are valid for Excel 2010 but I think they work for 2016 as well.)
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Thank you so much. Works perfectly! Appreciate your help.
You're welcome and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks