-
Solved: Macro to unprotect and protect in shared workbook
This site has been so helpful to me and I am extremely thankful for that. I have another question.
This question has been x-posted here.
I have a macro that needs my sheets to unprotect to run, so I have it unprotect, then do it's thing, then protect the sheets again. However, I need my workbook to be shared and I cannot unprotect my shared workbook. The macros just won't work if the workbook is shared. Does anyone know a way around this?
-
I've marked this topic solved because I realize there is no way around this. I will simply accomodate the obstacle by leaving the workbook unshared and allowing only 1 user to make changes at a time. Thank you for you time.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules