Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spell Check Protected WORKBOOK
Hi Everyone,
I have found the Macro code to check spelling for one particular worksheet. However, I want the macro to check the spelling in all 10 worksheets. This is what I am using now. Sub SpellCheckIt() Sheets("Sheet1").Unprotect "Password" ActiveSheet.CheckSpelling Sheets("Sheet1").Protect "Password" End Sub Thank you, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spell Check Protected WORKBOOK
Hi,
Am Tue, 11 Jun 2013 19:06:41 +0100 schrieb tso: However, I want the macro to check the spelling in all 10 worksheets. try: Sub SpellCheckIt() Dim i As Integer For i = 1 To Sheets.Count With Sheets(i) .Unprotect "Password" .CheckSpelling .Protect "Password" End With Next End Sub Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using Spell check on protected sheet | Excel Worksheet Functions | |||
Spell Check with protected sheets | Excel Discussion (Misc queries) | |||
Spell check protected sheet | Excel Discussion (Misc queries) | |||
Spell Check in Protected Worksheet & Shared Workbook | Excel Discussion (Misc queries) | |||
Spell Check in Protected Worksheet & Shared Workbook continued | Excel Discussion (Misc queries) |