Welcome back to another blog post in my #ExcelTips #MacroMonday Excel 2021 series. There a few ways to run an Excel macro. Hit the F5 key or the Run button while in the VBA window. But, sometimes a giving the user a warning before the macro is run, or ask if they are sure they want to run it the macro is a good safety net. The Yes No message box is a really good way to do this. The logic is simple. Hit Yes and the code or macro runs. Hit No, the code stops running. You are asking are you … [Read more...]

Hello Excellers and welcome back to another #MacroMonday blog post in my #Excel 2020 Excel tips series. Today we will write an Excel macro that will very quickly convert all of your formulas into values. Yes, that is correct, this macro will convert all Excel formulas into absolute values with one click of the mouse. Prepare To Write The Macro. First, open the Visual Basic Editor.  There are two ways to do this.  Hit ALT +F11 orSelect the Developer Tab | Code … [Read more...]

Hello, Excellers. Welcome back to another #MacroMonday #Exceltips blog post in my 2021 series. Want a very fast way to remove formatting from a range of cells then this is the macro you need. This Excel macro clear formatting from a user-selected range of cells with the click of a mouse. Great. Let's get coding. Read All of my Macro Monday Blog Posts Prepare To Write The Macro. First, open the Visual Basic Editor.  There are two ways to do this.  Hit ALT +F11 or … [Read more...]

Hello Excellers. Welcome back to another #MacroMonday #ExcelTip blog post in my Excel 2021 series. Do you need to password protect all of your Excel worksheets in a workbook at the same time?. Yes?. Well., you have come to the right Excel tip blog post. Let's get coding. This really is a simple but very useful few lines of code. Starting The Macro. First, open the Visual Basic Editor.  There are two ways to do this.  Hit ALT +F11 or Select the Developer Tab | Code … [Read more...]

Hello, Excellers. Welcome back to another #Excel #MacroMonday blog post in my Excel 2021 series. Today, I will show you how to easily copy the active worksheet to a new Excel worksheet with a small bit of Excel VBA macro Code. This is a real timesaver. With one click you can easily make a copy of your Excel worksheet you are working on. Read All of my Macro Monday Blog Posts Prepare To Write The Macro. First, open the Visual Basic Editor.  There are two ways to do … [Read more...]