Hello
I am using Excel 2010.
I found the following code on the internet and have it working to spell check a protected worksheet:
In the same way that I would spell check multiple sheets if not protected, I selected many worksheets and ran this macro but it didn't look at all worksheets. How can I get it to spell check as many worksheets as I select?
Thanks very much.
I am using Excel 2010.
I found the following code on the internet and have it working to spell check a protected worksheet:
Code:
Sub spellcheck()
ActiveSheet.Unprotect
Cells.CheckSpelling customdictionary:="CUSTOM.DIC", ignoreuppercase:=False, _
alwayssuggest:=True, SpellLang:=1033
ActiveSheet.Protect
End Sub
In the same way that I would spell check multiple sheets if not protected, I selected many worksheets and ran this macro but it didn't look at all worksheets. How can I get it to spell check as many worksheets as I select?
Thanks very much.