View Single Post
  #1   Report Post  
tso tso is offline
Junior Member
 
Posts: 1
Default 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,