How to move, copy, hide and protect Worksheets

We learn:

• How to set a variable called “LastSheet” to quickly refer to the last sheet in a workbook
• How to move a worksheet before / after another worksheet
• How to copy a worksheet before / after another worksheet
• How to set a worksheet to hidden or very hidden (and what this means in Excel) and how to unhide sheets
• How to set up a password to protect a worksheet

Tip: You can use the Macro Recorder to create code for moving, copying, hiding and protecting worksheets. This is a quick way to find out what VBA methods and properties to use.

Remember: Download the Module 6 PDF as a quick reference guide with sample VBA code.

Write your comments and feedback below

• If you have questions or comments about this lesson, write it in the section below.
• Alternatively you can email the instructor Victor at [email protected]