Because I protect my sheet the spelling check doesn't work..how can I send the F7
function to open spellchecker and only check the L2 box then close?
Currently the first script will opens the spellchecker, but it wants to spell check the whole document
instead of just L2??
Sub SpellCheckCell1()
' UnProtects the Roll Call Sheet, allows spell check and protects the sheet again
ActiveSheet.Unprotect
With Worksheets("Role Call").Range("L2").CheckSpelling
End With
ActiveSheet.Protect AllowSorting:=True, AllowFiltering:=True, AllowFormattingCells:=True
I tried application.sendkey ("{F7}"), but nothing happened..
Sub SpellCheckCell1()
'UnProtects the Roll Call Sheet, allows spell check and protects the sheet again
ActiveSheet.Unprotect
Range("L2").Select
Application.SendKeys ("{F7}")
ActiveSheet.Protect AllowSorting:=True, AllowFiltering:=True, AllowFormattingCells:=True
function to open spellchecker and only check the L2 box then close?
Currently the first script will opens the spellchecker, but it wants to spell check the whole document
instead of just L2??
Sub SpellCheckCell1()
' UnProtects the Roll Call Sheet, allows spell check and protects the sheet again
ActiveSheet.Unprotect
With Worksheets("Role Call").Range("L2").CheckSpelling
End With
ActiveSheet.Protect AllowSorting:=True, AllowFiltering:=True, AllowFormattingCells:=True
I tried application.sendkey ("{F7}"), but nothing happened..
Sub SpellCheckCell1()
'UnProtects the Roll Call Sheet, allows spell check and protects the sheet again
ActiveSheet.Unprotect
Range("L2").Select
Application.SendKeys ("{F7}")
ActiveSheet.Protect AllowSorting:=True, AllowFiltering:=True, AllowFormattingCells:=True