View Full Version : Solved: Macro to unprotect and protect in shared workbook

02-03-2006, 11:45 AM
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 (http://www.mrexcel.com/board2/viewtopic.php?t=193073).

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?

02-03-2006, 01:10 PM
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.