Allowing functionality on locked spreadsheets

[sparky2205]

Hi folks,
I have some locked spreadsheets which the users want to be able to perform a spellcheck on. By default spellcheck is disabled when the worksheet is locked.
As far as I can see the only method of enabling the spell check is by way of a macro.
Am I missing something simple? I can't see the logic of disabling the spell check on a locked worksheet.
I have another question on the same topic.
Exactly what does Format Cell allow you to do when protecting a worksheet?
I know you can change data types and wrap text etc.
But it doesn't allow e.g. merge cells.
Again I see the macro route as the only option to allow merging of cells in a protected worksheet.
Is this the case?

Thanks.

 

[Jeffrey Mahoney]

Yeah, I think you're right. I had to create a macro to do a spell check on a locked sheet. Basically, Unlock the sheet, perform the spell check, lock the sheet again. When the spell checker works, it needs to be able to change the cell contents, which a protected sheet blocks.

Format Cell allows you to change the font, text color, BG color, lines, and so on. Cell contents is protected.

 

[sparky2205]

Hi Jeffrey,
of course, when you put it like that it makes perfect sense.
In both cases, correcting using the spell check or merging cells, would mean changing the cell contents.
Obviously this won't be allowed on a locked sheet.
Makes sense when you think about it logically rather than it's just a spell check.
Thanks for your help.