Excel 365 Visual Basic Part 39– Worksheets

It is important to manipulate worksheets (located on the bottom of the Excel screen) in order to name them, insert new ones, move, copy, and reorganize. Using Visual Basic to do this can be done in a single command. This can also be performed on Workbooks which will allow you to name a file, create new workbooks, move, copy, and reorganize them. You will learn syntax to manipulate Worksheets, add additional Worksheets, and place data across Worksheets.

Video Series Part 39- This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-5-ch9.mp4

- Click + Rumble if the video was helpful.
- Click Subscribe so you won’t miss out on any new videos.
- Click the Share button so you can help others expand their skills.

Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video.

Courseware: Excel 365 – Visual Basic For Excel
The courseware is available on Amazon at: https://www.amazon.com/dp/1979929076

Chapter 9 - Worksheet And Workbook Manipulation
It is important to manipulate worksheets (located on the bottom of the Excel screen) in order to name them, insert new ones, move, copy, and reorganize. Using Visual Basic to do this can be done in a single command. This can also be performed on Workbooks which will allow you to name a file, create new workbooks, move, copy, and reorganize them. You will learn syntax to manipulate Worksheets, add additional Worksheets, and place data across Worksheets.

Section 1 - Worksheets
It is important to manipulate Worksheets (located on the bottom of the Excel screen) in order to name them, insert new ones, move, copy, and reorganize. Using Visual Basic to do this can be done in a single command. There are multiple ways to identify a sheet. It can be identified by the name, physical order, or visual order. Once identified, the Activate command can select it, and once selected, additional operations can be performed. There are commands to extract the total sheets available, and Sheets can be Hidden and made Visible. One unique command is the Very Hidden parameter which will hide a sheet. It can’t be unhidden unless you use a Visual Basic program. The following sheet manipulation commands will be covered: Visible Sheet Name, Order Created, Index Number, Activate, Select, Select 2 Worksheets, Name Property, ActiveSheet Object, Add Default, Add Worksheet, Delete Worksheet, Extract Sheet Name, Rename Worksheet, Count Property, Move Worksheets, Copy Worksheets, Paste Method, Hide Worksheets, Unhide A Worksheet, Very Hidden, Protect All Sheets, Unprotect All, and Add Password.

Section 2 - Workbooks
This section will allow you to name, create, move, copy, and reorganize Workbooks. You can also define an active Workbook that is open if you have more than one open. Also, you can protect a Workbook and close all open files except the active one. The following concepts will be covered: Workbooks, Activate, Save As, Copy Method, List Workbook Names, Protect Sheets, and Close All Workbooks.

This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.

If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com