Spell Checker

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi...

I want spell checker to run on 2 protected sheets from either to either. The
user has no access to menus or toolbars but presses a macro button to
commence the spell checker...Is there any simple code out there that does
this?

Thanks in advance.

Gordon
 
Here's about as easy a code as I could come up with. It will check both
pages but will only show the page that is active when it is run.

Sub spell_check()

Worksheets("Sheet1").Cells.CheckSpelling SpellLang:=1033
Worksheets("Sheet2").Cells.CheckSpelling SpellLang:=1033

End Sub

' This second example switches to the page the spell check is being run
on.

Sub spell_check2()

Worksheets("Sheet1").Select
Cells.CheckSpelling SpellLang:=1033
Worksheets("Sheet2").Select
Cells.CheckSpelling SpellLang:=1033

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasted text will not spell check 5
Spell Checking on a protected sheet 1
Spell-check problem 0
Spell checking textbox on a userform 10
MS Acccess Spell Checker VBA code 0
Spell Checker has decided I speak a different language for me 1
Compatability Checker Question 3
spellchecking only the unlocked cells of a protected spreadsheet? 5

Back
Top