Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Spelling Check
Hello all,
I have an Excel file that password-protects the worksheets and workbook. Due to the password-protecting the worksheets, the Spelling option under Tools menu is not available. Could someone help me with a code to have the Spelling option enabled while the worksheets are password-protected? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Spelling Check
Hello:
If you have your worksheet protected, then you could put two buttons on the worksheet: one to unprotect, and one to protect. This is useful if you are not concerned with security and just want to keep the user from altering items by mistake. Here are the subroutines... use your own passwords. I used this technique for a similar purpose with the understanding that the user would not attempt anything unusual while in an unprotected state. Sub Btn_UnProtect() ' Sheets("POMIS").Select ActiveSheet.Unprotect Password:="rob" End Sub Sub Btn_Protect() ' Sheets("POMIS").Select ActiveSheet.Protect Password:="rob", DrawingObjects:=False, Contents:=True, Scenarios:= _ False, AllowSorting:=True, AllowFiltering:=True End Sub -- Rich Locus Logicwurks, LLC "Accesshelp" wrote: Hello all, I have an Excel file that password-protects the worksheets and workbook. Due to the password-protecting the worksheets, the Spelling option under Tools menu is not available. Could someone help me with a code to have the Spelling option enabled while the worksheets are password-protected? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Spelling Check
Rich,
Thanks for your response. The worksheets will always be protected, and I am looking for a code that would enable the Spelling option under Tools while the worksheets are password-protected. I do not understand one thing is there is a code "EnableFilter", and why there is no code for "EnableSpelling". Thanks. "Rich Locus" wrote: Hello: If you have your worksheet protected, then you could put two buttons on the worksheet: one to unprotect, and one to protect. This is useful if you are not concerned with security and just want to keep the user from altering items by mistake. Here are the subroutines... use your own passwords. I used this technique for a similar purpose with the understanding that the user would not attempt anything unusual while in an unprotected state. Sub Btn_UnProtect() ' Sheets("POMIS").Select ActiveSheet.Unprotect Password:="rob" End Sub Sub Btn_Protect() ' Sheets("POMIS").Select ActiveSheet.Protect Password:="rob", DrawingObjects:=False, Contents:=True, Scenarios:= _ False, AllowSorting:=True, AllowFiltering:=True End Sub -- Rich Locus Logicwurks, LLC "Accesshelp" wrote: Hello all, I have an Excel file that password-protects the worksheets and workbook. Due to the password-protecting the worksheets, the Spelling option under Tools menu is not available. Could someone help me with a code to have the Spelling option enabled while the worksheets are password-protected? Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Spelling Check
Hello:
I researched your request, and reviewed some of the MVP responses from past years on this issue. The spreadsheet MUST be unlocked to do a spell check, but here was a suggestion from one MVP... create a "Spell Check" button and use this macro (again, this came from another MVP): Sub SpellCheckIt() Sheets("Sheet1").Unprotect "password" ActiveSheet.CheckSpelling Sheets("Sheet1").Protect "password" End Sub -- Rich Locus Logicwurks, LLC "Accesshelp" wrote: Hello all, I have an Excel file that password-protects the worksheets and workbook. Due to the password-protecting the worksheets, the Spelling option under Tools menu is not available. Could someone help me with a code to have the Spelling option enabled while the worksheets are password-protected? Thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Spelling Check
Rich,
Thank you very much for taking the time to do the research and following up with me. I am aware of the code "CheckSpelling" and the code from below, and I am trying to avoid using the code from below, if possible. I guess that is the only option available, and it's kind of make sense that how can you check for spelling and fix the spelling if the worksheet is protected. Thanks again. Have a great weekend! "Rich Locus" wrote: Hello: I researched your request, and reviewed some of the MVP responses from past years on this issue. The spreadsheet MUST be unlocked to do a spell check, but here was a suggestion from one MVP... create a "Spell Check" button and use this macro (again, this came from another MVP): Sub SpellCheckIt() Sheets("Sheet1").Unprotect "password" ActiveSheet.CheckSpelling Sheets("Sheet1").Protect "password" End Sub -- Rich Locus Logicwurks, LLC "Accesshelp" wrote: Hello all, I have an Excel file that password-protects the worksheets and workbook. Due to the password-protecting the worksheets, the Spelling option under Tools menu is not available. Could someone help me with a code to have the Spelling option enabled while the worksheets are password-protected? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check spelling as you type | New Users to Excel | |||
enable and repurpose the Spelling control? | Excel Programming | |||
... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
Spelling check in excel | Excel Programming | |||
Spelling check | Excel Programming |