| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using Spell check on protected sheet
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using Spell check on protected sheet
I had thought of a Macro - however would one macro allow someone to stop and
correct the spelling and then continue to protect the sheet? Or would it involve two macros? -- Thanks, Pat "Mike H" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using Spell check on protected sheet
Hi,
The macro I gave you does precisely that, it unprotects the sheet for the spellcheck and re-protects on completion. Mike "Pat" wrote: I had thought of a Macro - however would one macro allow someone to stop and correct the spelling and then continue to protect the sheet? Or would it involve two macros? -- Thanks, Pat "Mike H" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using Spell check on protected sheet
WOW! that is awesome.
One more snag thou - is it possible to choose the area that we want spell check to work on? This particular file has a lot of abbreviations and formulas which spell check stops at. The area I would like to have checked is B7 - I25 Thanks again. -- Thanks, Pat "Mike H" wrote: Hi, The macro I gave you does precisely that, it unprotects the sheet for the spellcheck and re-protects on completion. Mike "Pat" wrote: I had thought of a Macro - however would one macro allow someone to stop and correct the spelling and then continue to protect the sheet? Or would it involve two macros? -- Thanks, Pat "Mike H" wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using Spell check on protected sheet
Pat,
Simplt specify the range Sub Stantial() ActiveSheet.Unprotect Password:="MyPass" ActiveSheet.Range("B7:I25").CheckSpelling SpellLang:=2057 ActiveSheet.Protect Password:="MyPass" End Sub Mike "Pat" wrote: WOW! that is awesome. One more snag thou - is it possible to choose the area that we want spell check to work on? This particular file has a lot of abbreviations and formulas which spell check stops at. The area I would like to have checked is B7 - I25 Thanks again. -- Thanks, Pat "Mike H" wrote: Hi, The macro I gave you does precisely that, it unprotects the sheet for the spellcheck and re-protects on completion. Mike "Pat" wrote: I had thought of a Macro - however would one macro allow someone to stop and correct the spelling and then continue to protect the sheet? Or would it involve two macros? -- Thanks, Pat "Mike H" wrote: 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using Spell check on protected sheet
PERFECT!!
Mike you are my HERO! Thank you very much for your quick response and great info. ;) Have a wonderful weekend. -- Thanks, Pat "Mike H" wrote: Pat, Simplt specify the range Sub Stantial() ActiveSheet.Unprotect Password:="MyPass" ActiveSheet.Range("B7:I25").CheckSpelling SpellLang:=2057 ActiveSheet.Protect Password:="MyPass" End Sub Mike "Pat" wrote: WOW! that is awesome. One more snag thou - is it possible to choose the area that we want spell check to work on? This particular file has a lot of abbreviations and formulas which spell check stops at. The area I would like to have checked is B7 - I25 Thanks again. -- Thanks, Pat "Mike H" wrote: Hi, The macro I gave you does precisely that, it unprotects the sheet for the spellcheck and re-protects on completion. Mike "Pat" wrote: I had thought of a Macro - however would one macro allow someone to stop and correct the spelling and then continue to protect the sheet? Or would it involve two macros? -- Thanks, Pat "Mike H" wrote: 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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using Spell check on protected sheet
Glad I could help
On Fri, 13 Mar 2009 14:05:01 -0700, Pat .(donotspam) wrote: PERFECT!! Mike you are my HERO! Thank you very much for your quick response and great info. ;) Have a wonderful weekend. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| spell check on protected sheet | Excel Discussion (Misc queries) | |||
| Spell check protected sheet | Excel Discussion (Misc queries) | |||
| Protected sheet spell check | Excel Discussion (Misc queries) | |||
| Spell check in a protected sheet | Excel Discussion (Misc queries) | |||
| spell check in an Excel protected sheet | Excel Discussion (Misc queries) | |||
![Pat[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
