Skip to main content
Excel Macro: Save and Close All Workbooks at Once
Sometimes you may need to save and close many workbooks at once, this Excel macro maybe help you. Get this VBA code now!
Excel Macro: Saving a Workbook When a Specific Cell Is Changed
Sometimes, you may want to save a workbook when a specific cell is changed or range of cells is changed. This macro can help you. Get it now!
Excel Macro: Rename a File or Folder
You can rename and move a specified file or folder using the built-in Name statement in VBA. Download this Excel macro now!
Testing the Macro
You will learn: Three methodes of test the Macros. Take this free course now!
Viewing macro code
You'll learn: How to view Excel macro code and what Excel macro code looks like. Take this free course now!
Editing your macro
You will learn: how to edit your Excel macro code and how to optimize Excel macro code. Take this free course now!
Absolute References or Relative References
You will learn: What's the difference between absolute and relative references. How to record macros with two modes. Take this course now!
Saving macros
You will learn: Save as Macro-enabled workbook, Understanding which file types allow macros. Take this free course now!
Personal Macro Workbook
You will learn: Introduction to the Personal Macro Workbook. How to Store macro in Personal Macro Workbook and show it . Take this course now!
Macro security
You will learn: Enable or Disable Excel Content, Excel Macro Security Settings and Excel Macro Trusted Locations. Take this free course now!
Adding a Macro on the Quick Access toolbar
You will learn: How to assign a Macro on the Excel Quick Access toolbar. Take this free course now!
Assigning a Macro to a Button
You will learn: How to assign a Macro to any Excel worksheet object, such as a button, a picture, or an icon... Take this course now!