Hello Excellers and welcome to another #Excel #MacroMonday blog post in my 2021 series. I want to show you how to export and save all of your Excel worksheets in an Excel workbook as separate PDF files. This is particularly useful if you have as in my example multiple sales regions and you need to save the worksheets for each region in their own file. In my example, I have four sales regions. I need to save each region's report separately and send it as a PDF file to the regional … [Read more...]
Macro Mondays – Running An Excel Macro From The Immediate Window

Hello, Excellers welcome to another #MacroMonday #Excel blog post in my 2021 Excel Macro series. Today let's take a look at using the Immediate Window in the Excel VBA debugging environment. This environment can be used as a type of scratchpad or sandbox area and has many uses as well as debugging code. You will need to first Enable The Developer Tab if it is not already enabled. You can watch my YouTube Video for instructions. https://youtu.be/CYcyoBMTZ44 If you … [Read more...]
Macro Mondays – How To Assign An Excel Macro To A Button Or Assign A Button To An Excel Macro

Hello, Excellers Welcome back to another #Excel blog post in my #MacroMonday 2021 series. I want to show you how to assign an Excel Macro to a button or assign a button to an Excel Macro, whichever way you want to say it!. There are a few ways to run an Excel Macro that you have created. A brief summary of which can be seen below. Run the Macro from the Immediate Window in the Visual Basic screen. (you can read more about Running An Excel Macro From The Immediate WindowYou can … [Read more...]
Excel VBA to Insert Multiple Rows Based On Cell Value
by Barbara

Hello, Excellers and welcome back to another #MacroMonday #Excel blog post in my 2021 Excel series. Today I want to show you how to write s macro to insert and copy a number of new Excel rows into your spreadsheet. The number of rows, however, will be variable and will depend on a cell value. This is a nice flexible alternative solution to inserting a standard number of rows after each data containing data in Excel. My YouTube video solution to that is linked … [Read more...]
How To Enable And Disable Macros In Excel.
by Barbara

Hi, Excellers. Welcome back to another blog post in my new year of 2021 #MacroMonday Excel series. Today let's take a look at how to enable and also disable Macros in Excel. Now, Excel Macros can be used for good or not so good. So, as a consequence, you have a choice to enable them or disable them in Excel. We can also store them in trusted locations. With the release of Excel 2010, the security model changed significantly to previous versions. It introduced the concept of 'Trusted … [Read more...]
- 1
- 2
- 3
- …
- 34
- Next Page »