Formatting Cells Font with VBA
You can learn: Formatting Cells Font with VBA, include Font Name, Font Style, Font Size, Underline, Font Color and Font Effects.
Formatting Cells Border with VBA
You can learn: Formatting Cells Border with VBA, include Border Index, Line Style, Line Thickness and Line Color. Take this free course now!
Where should I put the Excel VBA code?
This course describes the different types of modules in Excel VBA, and what you should and shouldn't put in each type. Take this course now!
Formatting Cells Fill with VBA
You will learn: Formatting Cells Fill with VBA, include Background Color, Fill Effects, Pattern Color and Pattern Style. Take this course now!
Formatting Cells Protection with VBA
You will learn: Formatting Cells Protection with VBA, include Locking Cells and Hiding Formulas. Take this course now!
Excel Macro: Unhide All Worksheets in a Workbook
If you want to unhide all Worksheets in a Workbook at once, this simple macro makes easy work for you. Get this VBA code now!
Excel Macro: Delete All Worksheets Except Active One
If your Workbook have many Worksheets and you want to delete all Worksheets except the active one, you can use this simple macro. Get it now!
Recording a macro
You will learn: Recording a macro, The Record Macro dialog box settings and Excel Macro Recorder Limitations. Take this free course now!
Excel Macro: Add and Name a New Worksheet with Specific Name
If you always add and name a new Worksheet with specific name in your Workbook, this simple macro can help you. Get this VBA code now!
Excel Macro: Create a Backup of a Workbook with Current Date
This simple macro can backup your workbook with today's date as part of the file name in the Same folder. Get this VBA code now!
Excel Macro: Prevent the Workbook Closing If a Cell is Empty
If you want to to make sure the user has entered all the required fields before saving and closing Excel. This is where this macro comes in.
Excel Macro: Print All Workbooks in a Folder
Opening and printing each workbook in a folder is typically a time consuming manual process. This little macro takes care of that annoyance.