Skip, I've read the limitations, but I find it's a little vague. It says that macros will stop once they come up against an invalid instruction. I guess the real question is if there's a way to share or unshare a workbook programmatically.
I was afraid of that... Seeing as the question is more related to spellcheck in a shared protected workbook & sheet, I'll post a new thread.
http://www.tek-tips.com/viewthread.cfm?qid=1123352&page=1
I've got a workbook that our office uses to pass along information. Each sheet is protected as well as the workbook, and it's shared (there are about 20 users per day, and none of them are very computer-friendly). Unfortunately, most of them can't spell either. I'd like to be able to use the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.