About Protecting and Unprotecting Worksheets

Latest Version - V Planner V4.3

V Planner 4.2, High School V Planner V4.2, and Homeschool Lesson Planner V4 are ready for use. Download from the Member's area. requires login

All of the important V Planner worksheets are protected. A few worksheets have password protection and the password is on the worksheet so that you can unprotect the worksheet if needed. And then there are the 3 worksheets, SC, IC, and ICY that are locked and no password is given. Those 3 worksheets are vital to the functions of the V Planner and tinkering is absolutely not allowed. If any one of those 3 worksheets, SC, IC, and ICY, is deleted, the V Planner will not work.

Be sure to read How to Lose V Planner Support

Unprotecting Worksheets

The only good reason to unprotect a worksheet is to fix a bug and when a bug is found, I will post instructions. Part of the instructions is to protect the worksheet after applying the fix.

If you unprotected a worksheet for another reason and if you break it, you are on your own. You will have to download another V Planner, set it up, and then, don't break it.

Unprotecting in Older Excel

To unprotect a worksheet in older Excel - this would be Excel 2002-'03 or the versions with the older menu.

  1. Go to Tools
  2. Protection
  3. Unprotect Sheet

Unprotect

Unprotecting in Newer Excel

To unprotect a worksheet in newer Excel - this would be Excel 2007+ or the versions with the ribbon menu.

  1. Go to Review
  2. Unprotect Sheet

Unprotect

Protecting Worksheets

After unprotecting a worksheet, you should always protect the worksheet when you are finished with whatever you needed to do.

Protecting in Older Excel

To protect a worksheet in older Excel - this would be Excel 2002-'03 or the versions with the older menu.

  1. Go to Tools
  2. Protection
  3. Protect Sheet

Protecting in Newer Excel

To unprotect a worksheet in newer Excel - this would be Excel 2007+ or the versions with the ribbon menu.

  1. Go to Review
  2. Protect Sheet
  3. In the window that apprears next, choose OK

Protect

Donna Young
Updated

About the V-PlannerYoungMinds CD-Rom

How to access the V PlannerThe V Planner is a spreadsheet file in xls and xlsx format. To use the file, you must have Microsoft Excel on your computer. The V Planner is available from YoungMinds web site. YoungMinds is online via a subscription and on Donna Young's Site-CD.

Donna Young

dated personal journal for the household planner

Blank Comic Strips - Draw Your Own Comic Strips!

You are at DonnaYoung.org, online since 1998. Thank you for visiting my website. Donna Young

Back to Top