Allowing functionality on locked spreadsheets

sparky2205

Active Member
Joined
Feb 6, 2013
Messages
282
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,768
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

Active Member
Joined
Feb 6, 2013
Messages
282
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,789
Messages
5,524,885
Members
409,609
Latest member
Channingz

This Week's Hot Topics

Top