Hello Excellers, welcome back to another #MacroMonday blog post in my #Excel 2021 series. Today I will share a quick and simple Excel Macro. It allows a user to insert as many new worksheets into their Excel workbook as they need to. An Input Box is used to collect the number of worksheets needed. The code is available at the end of the blog post. So, sit back and enjoy inserting multiple new worksheets at the click of a mouse. Yes, that is correct, no more right click and insert … [Read more...]
How To Save Excel Worksheets As Separate PDF Files.

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...]
Password Protect An Individual Worksheet.
by Barbara

Hello, Excellers and welcome back to another #MacroMonday #Excel tip blog post in my 2020 series. Today I want to show you how to password protect an individual worksheet in your Excel workbook. This is really handy if you have a particular worksheet you do not want users to access without entering a password. There are a few stages to this tip, it involves getting into some Excel Visual Basic code, but is very straightforward. So, we have a workable example, a workbook with two … [Read more...]
- 1
- 2
- 3
- …
- 34
- Next Page »