Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi there and welcome
It could be done via a macro
Which is the oldest version of Excel the sheet is used on?
Ok, the best is via a button.
You would make a button and use this code.
Sub SpellCheck()ActiveSheet.UnprotectCells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False, AlwaysSuggest:=True, SpellLang:=1033ActiveSheet.ProtectEnd Sub()
Then have the button run the code. If there is a password ***** it you would put the password ***** the unprotect and protect work in my code.
Are you able to implement this?
I have made an offer, if you accept it I can do it on your sheet for you
I cannot see as I am not able to see how you implemented it or other factors in your sheet.
But if I did it on the sheet you now have, then you can keep working on it once done.
Yes you could, once you accept the offer, yes it is $39, then have her upload it to this link
It is secure, and not available publically unless you have the link but I remove the file once done.
If you have any problems, or would like any additional information or assistance, please do not hesitate to let me know.
And please take a second to rate my service for now by clicking one of the stars at the top of the screen then submit