Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kaeptn

  1. kaeptn

    noob question with line/field protection

    Hi, i want to protect just one line in the whole sheet. But it's not working :-( Can anybody give my a hint what i'm doing wrong ? Here is the code i wrote: Sheets("tabelle1").Activate Cells.Select Selection.Locked = False Range(A1, Z1).Locked = True Sheets("tabelle1").Protect...

Part and Inventory Search

Back
Top