Allowing functionality on locked spreadsheets

sparky2205

Active Member
Joined
Feb 6, 2013
Messages
386
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.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
2,061
Office Version
  1. 365
Platform
  1. Windows
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
386
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,826
Messages
5,855,875
Members
431,771
Latest member
CoryMelth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top