Dissect and Learn Excel VBA in 24 Hours is a series of quick references for intermediate users who are looking for ideas and samples of VBA code to accomplish certain tasks when they are in the process of writing a program. In this series, you will see thousands of tiny working parts of VBA code that are used to accomplish many simple and yet meaningful tasks. To add a new workbook, to auto-fill a range, to sort a table of data, to generate a table of contents for all chart sheets and worksheets in a workbook, to loop through and manipulate a folder of Excel files, to place a control on the Ribbon, to send an email, and to login to an account in the Internet are some examples of these tiny working parts.

This series is for readers, who have at least a basic understanding of Excel VBA programming. In order to follow the discussions in the series, a reader must know what Sub procedures and Function procedures are, what Visual Basic Editor (VBE) is, how to add a VBA module to a workbook, how to set a reference to an application's type library, how to enable the Auto List Members feature in VBE, how to use the Macro Recorder in Excel in order to find out the methods and properties of objects that you are not familiar with, how to use the Object Browser to check the complete list of members for a particular object, how to write some simple procedures, in which VBA modules you should store your VBA code, and how to use the debugging tools in VBE. If you are new to Excel VBA, please teach yourself Excel VBA before exploring the contents in the series. You may refer to my earlier book entitled Learn Excel® VBA in 24 Hours - A quick reference for beginners, which was written for those who are new to Excel VBA. I hope this series of books will serve as quick references in facilitating you to write an unlimited number of working VBA programs. Let Excel VBA work for you.

Book 1: Changing workbook appearance focuses on changing the appearances of the worksheet cells, the worksheets of a workbook, the row and column headings, the sheet tabs, the layout view of a worksheet, the status bar, the formula bar, the Ribbon, and the Cell context menu. Figure 1 shows the components that will undergo certain changes in their appearances. In this book, almost half of it covers on how to customize the Ribbon. The main purpose of changing the appearance is to let the users to have a better working experience when they are using your program. The changes may affect from just a worksheet cell, a range of cells, and a worksheet to the entire active workbook and every opened workbook. To see how the code affects the appearance, simply copy and paste the code into the Immediate window, a VBA module, or Custom UI Editor, and run the VBA code (or step through the VBA code by using the debugger in VBE) or reopen the workbook file (that stores the code) in Excel. This book ends with a sample program that adopts most of the ideas that are discussed in the book.

You can download the related code file(s) from https://drive.google.com/drive/folders/1Qbw5BWFD3f9w2pM_pDa_CVyeHIKXTkEV?usp=sharing

• We started tracking this book on February 1, 2021.
• This book was £3.17 when we started tracking it.
• The price of this book has changed 37 times in the past 1,193 days.
• The current price of this book is £4.55 last checked 11 hours ago.
• This lowest price this book has been offered at in the past year is FREE.
• The lowest price to date was FREE last reached on April 26, 2024.
• This book has been FREE 17 times since we started tracking it.
• The highest price to date was £4.55 last reached on April 29, 2024.
• This book has been £4.55 3 times since we started tracking it.
• This book is currently at its highest price since we started tracking it.

• ComputingApplications & SoftwareOffice SoftwareSpreadsheets
• ComputingProgrammingMicrosoft Programming

• Text-to-Speech: Enabled
• Lending: Disabled
• Print Length: 163 Pages
• File Size: 16,231 KB