Protected Sheets, Shared Workbook & Spellcheck...

[hobar]

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 spellcheck on the unlocked parts of the sheets.

I'm trying to avoid using VBA, because it's a shared workbook and I'm not sure of the restrictions, but does anyone have any hints or tips that don't involve my coworkers going back to grade school?

 

[SkipVought]

Hi,

Have you looked at HELP for limitations of shared workbooks?

What did you find?

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[Benoni2]

I used the code:

activesheet.unprotect ("password")
activesheet.protect ("password")

around my spell check macro code. All it did was run the macro, but if there were locked fields or protect parts of the workbook, it disabled the spell checker all together. This code above was slick because it unlocked the whole document while it ran the code, but locked it before the user could touch the form.

 

[SkipVought]

So what's the problem?

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[hobar]

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.