Spell check on protected cells

[grumpus]

I have a spreadsheet with protected cells and areas where I need users to input data. Once I lock the spreadsheet to protect the cells, users cannot run spellcheck on their work to the areas where data is permitted to be entered. Is there a non-macro way in which spellcheck can be activated in this example? If not, what would be the most efficient macro approach? Thanks as always.


Grumpus

 

[Luke M]

A macro is the only way to go. THere's several examples found via Google, but here's the first hit that looks promising:

http://www.mrexcel.com/forum/excel-questions/11177-spell-check-protected-sheet.html

 

[grumpus]

Great reference...many thanks Luke.