Dissect and Learn Excel® VBA in 24 Hours: Changing workbook appearance

No matter how complicated a program is, it is made of many smaller and tiny fundamental working parts of programming code. Each of them accomplishes a specific task. Some may just consist of only one or a few lines of code. Knowing the functions of these fundamental working parts, you can then easily write an unlimited number of working programs. And knowing them, you can easily understand the programs written by others and adopt into your programs the ideas and the VBA code that are presented in those programs.

Dissect and Learn Excel VBA in 24 Hours is a series of quick references to VBA code 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. 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.

The main purpose of changing the appearance is to let the users to have a better working experience when they are using your program. To facilitate the process of copying the code in the book and pasting it into VBE and Custom UI Editor, you may download the code from https://drive.google.com/file/d/0ByKhn-UYAjlQUTAtQTNoVVB6MTQ/view.This book ends with a sample program that adopts most of the ideas that are discussed in the book. You may download the program for Excel 2010-2016 (https://drive.google.com/file/d/0ByKhn-UYAjlQZ1Bvb0JqVzVxVTg/view) to see how it changes the appearance of a workbook.