ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Spell Check function on a protected sheet (https://www.excelbanter.com/excel-worksheet-functions/150036-spell-check-function-protected-sheet.html)

Mark

Spell Check function on a protected sheet
 
How can I enable the spell check button on a protected worksheet
--
Mark

ShaneDevenshire

Spell Check function on a protected sheet
 
Hi Mark,

You can't spell check a protected sheet. What do you want to do if there is
a spelling error? If the sheet is protected then you couldn't change the
contents of the cells, that is the whole idea behind protectiong. You can
turn protection off, spell check the sheet and then turn protection on. You
could write a VBA program to format the cells that spell check finds.
--
Cheers,
Shane Devenshire


"Mark" wrote:

How can I enable the spell check button on a protected worksheet
--
Mark



All times are GMT +1. The time now is 07:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com