View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default using Spell check on protected sheet

Pat,

Use a macro to fleetingly unprotect the sheet and then re-protect. Alt +F11
to open VB editor, right click 'ThisWorkbook' and insert module and paste the
code in

Put a button on your sheet to call it


Sub Stantial()
ActiveSheet.Unprotect Password:="MyPass"
ActiveSheet.Cells.CheckSpelling SpellLang:=2057
ActiveSheet.Protect Password:="MyPass"
End Sub

Mike


"Pat" wrote:

Hello,

I have selected sections of a worksheet and Unlocked the Cells so that when
I protect the sheet the user can still enter in certain cells. However
Spell Check is not available in any cells.

Is there a way to have the sheet protected but allow the user to the use of
Spell Check in the cells that they have access too.

I look forward to any help.

Thank you!
--
Thanks, Pat