Question: Using the VBA editor insert a new module and create a sub procedure named currentdate. Press ENTER two times. Enter code to unprotect the Sheet1
Using the VBA editor insert a new module and create a sub procedure named currentdate. Press ENTER two times. Enter code to unprotect the Sheet1 worksheet using the password eXpenses. Press ENTER again. Enter code that will automatically enter the current date in cell G4 Press ENTER, and then set column G to autofit, using cell G4 as the range. Press ENTER again. Enter code to italic cell G4. Press ENTER, and then enter code to relock the worksheet using the password eXpenses. Press ENTER again, and then close the VBA editor
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
