Need help writing the VBA code:

From this, you will need to learn VBA code to do the following: . Create a new worksheet and rename it . Change the Format of cells . Set a Name for a cell or range (Named Ranges) Unlock a cell Enter text (values) into a cell, formulas are the same but uses the Formula property .Copy and paste text . Remove the copy marquee (dotted lines) from a copied cell . Protect and unprotect a worksheet . Delete worksheets Further tips: Looking at your recorded macro, you will see lines such as: Range("A2").Select Activecell.FormulaR1C1"Looks Great!" In VBA code using a separate line to select an object first is not necessary, so in future assignments your code should look more like: Range("A2") .Value "Looks Great