Posts by PRivera

My Skill Level: Beginner

Where am I going wrong?

ActiveSheet.Unprotect Password:=“1234”

Cells.Checkspelling SpellLang:=1033

ActiveSheet.Protect Password:=“1234”, True, True

DrawingObjects:=True,

Contents:=True,
Scenarios:=True,

AllowFormattingRows:=True

Need VBA code to do following

1. Unprotect active sheet with known password

2. Run spell check

3. Protect active sheet with known password while allowing row formatting in protected mode