A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Allowing spell check on protected worksheets



 
 
Thread Tools Display Modes
  #1  
Old February 8th, 2005, 07:41 PM
Allowing spell check on protected worksh
external usenet poster
 
Posts: n/a
Default Allowing spell check on protected worksheets

Allow spell check for protected cells in a protected worksheet in Excel? I
wan to be able to spell check on protected cells that have a password
protection on the sheet(s).

Thanks,
Hans
  #2  
Old February 8th, 2005, 08:13 PM
Paul B
external usenet poster
 
Posts: n/a
Default

Hans, here is a way, unprotect the sheet checks the spelling and then
protects the sheet

Sub Spell_Check()

'spell check a protected sheet

ActiveSheet.Unprotect password:="123"

Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC",
IgnoreUppercase:=False _

, AlwaysSuggest:=True

ActiveSheet.Protect password:="123"

End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Allowing spell check on protected worksh" Allowing spell check on
protected wrote in message
...
Allow spell check for protected cells in a protected worksheet in Excel?
I
wan to be able to spell check on protected cells that have a password
protection on the sheet(s).

Thanks,
Hans



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Spell Check, on Word 2002; Other Languages June New Users 5 December 14th, 2004 03:31 PM
How do I spell check the text fields in a protected form? Darice Lewis General Discussion 1 October 1st, 2004 04:07 PM
Spell Check in protected Forms MH General Discussion 1 September 30th, 2004 03:07 AM
How can I spell check protected form fields in Word? Jacki General Discussion 1 September 23rd, 2004 08:16 PM
IE6+XP: Spell Check Halted? Mitch Outlook Express 1 June 7th, 2004 06:43 PM


All times are GMT +1. The time now is 10:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.