Macros & Excel VBA

Excel VBA: Wait Until a Process Completes

VBA provides us with a built-in method called Wait. We’ll use this method to wait until the process completes. The problem is the method Wait takes a ...

How to Edit a Macro Button in Excel (5 Easy Methods)

  Method 1 - Edit the Display Text of a Macro Button in Excel Steps: We have to create a macro button in Excel. We named it "Run the ...

How to Save a Workbook Without a Prompt with Excel VBA (Easy Steps)

Dataset Overview We've included a sample data set in the image below to demonstrate the difference after running the VBA codes to stop the ...

Cannot Edit a Macro on a Hidden Workbook – 2 Solutions

While trying to edit a Macro, a notification box is displayed: The Macro is not in the active workbook, it’s in a different workbook that is ...

Excel VBA to Save as File Using Path from Cell: 7 Methods

Method 1 - Make Dataset Ready Make the dataset ready. Select a cell and type or paste the path location. Because you need to assign the cell ...

How to Use Excel VBA to Save a Sheet as a New Workbook without Opening It (6 Examples)

Example 1 - Renaming a Sheet and Saving It as a New Workbook Open your workbook in Excel. Press Alt + F11 to open the Visual Basic for ...

How to Create Data Entry Form in Excel VBA (with Easy Steps)

Here we’ve got three worksheets called Washington, New York, and California that contain the names, contact numbers, ages, and genders of some ...

How to Save a Macro for All Workbooks in Excel (Easy Steps)

Step 1 - Open the Developer Tab in Excel Open an Excel workbook. Go to the Developer tab.  If it's hidden, follow these steps to unhide it. ...

How to Use a VBA Code for ‘Save Button’ in Excel (4 Methods)

How to Insert a Macro Button and Assign a Macro Before creating a VBA-Enabled Save Button, users must insert a Command Button and assign a Macro to ...

How to Use Excel VBA Macro to Save a PDF in a Specific Folder (7 Examples)

The following dataset contains the sale amounts of different salespeople. Method 1 - Using Excel VBA Macro to Save Active Worksheet as PDF ...

How to Choose a Location and Save a Workbook as a PDF Using VBA in Excel

  Sub Choose_Location_and_Save_as_PDF() PDF_Name = "MyPDF.pdf" Set File_Dialog = Application.FileDialog(msoFileDialogFolderPicker) ...

Excel VBA to Protect Sheet but Allow to Select Locked Cells (2 Examples)

To protect the sheet and allow select locked cells to edit, we are going to use the dataset below. The dataset contains some employee names in column ...

Excel VBA to Protect Range of Cells (3 Examples)

We have a dataset that contains formulas in the Savings column and the rest are values. Method 1 - Protect a Certain Range of Cells ...

Send Reminder Email Automatically from an Excel Worksheet Using VBA

The sample dataset below includes the emails of various people, as well as the deadlines they must meet for various reasons. We'll use a VBA macro to ...

Excel VBA Save as File Format (12 Suitable Examples)

To illustrate how to Save as in various ways using VBA, we’ll use the following dataset containing the Salesman, Product, and Net Sales data of a ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo