spell check a protected sheet

Feb 25th, 2002, 05:01 PM

Is there any way to have the spell check work on a protected sheet?

Derek · Feb 25th, 2002, 06:11 PM

Hi
One way would be to provide a macro button on your worksheet titled "Spell Check".
Record a macro which unprotects your sheet, then click on spell check, then reprotect your sheet. I tried this and it seems to work.
regards
Derek

Feb 26th, 2002, 05:12 AM

Thanks, Derek

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 25th, 2002, 05:01 PM	#1
Guest Posts: n/a	Is there any way to have the spell check work on a protected sheet?

Feb 25th, 2002, 06:11 PM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi One way would be to provide a macro button on your worksheet titled "Spell Check". Record a macro which unprotects your sheet, then click on spell check, then reprotect your sheet. I tried this and it seems to work. regards Derek