• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More
    • Blog
    • Download Area
    • Excel Video Tutorials
Home » VBA

Create A Yes No Message Box Before Running An Excel Macro.

April 12, 2021 by Barbara —Leave a Comment

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...]

Filed Under: Blog, Macro Mondays, Macros, VBA Tagged With: Blog, Macro Mondays, Macros

Convert All Formulas Into Values Excel Macro.

April 5, 2021 by Barbara —Leave a Comment

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...]

Filed Under: Blog, Macro Mondays, Macros, VBA Tagged With: Blog, Macro Mondays, Macros

Clear Formatting From Cells Macro

March 29, 2021 by Barbara —Leave a Comment

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...]

Filed Under: Blog, Macro Mondays, Macros, VBA Tagged With: Blog, Macro Mondays, Macros

Protect All Excel Worksheets At The Same Time.

March 22, 2021 by Barbara

password protect all Excel Worksheets

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...]

Filed Under: Blog, Macro Mondays, Macros, VBA Tagged With: Blog, Macro Mondays, Macros

Copy The Active Worksheet To A New Excel Workbook.

March 15, 2021 by Barbara

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...]

Filed Under: Blog, Macro Mondays, Macros, VBA Tagged With: Blog, Macro Mondays, Macros

  • 1
  • 2
  • 3
  • …
  • 38
  • Next Page »

Tags

Blog Cells Excel Excel Charting Excel Excel Tips Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Table Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2021 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in

Search

More Info

Want FREE Excel Tips?

Click on my FREE eBook, its my bonus for joining thousands of others who receive my 3 xFREE Excel tips every month in my Excel Newsletter. Join Us!.

Need Answers To Excel Questions Like These?

*How Do I Create A Timestamp In Excel?
*I Want To Change The Width Of The bars On My Excel Chart
*How Can I Find Out The Length Of My Text in Excel? Click the link below to receive more Excel tips' and my Free Ebook

New To Excel? This Is A Great Place To Start!!

Learn Excel Dashboard Course Excel Basics
Scrollbars
Colour of Sheet Tabs
Conditional Formatting
Calculations Introduction

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts

Video Tutorials-If You Like To Learn By Watching

Subscribe to YouTube to get notified of of new Excel videos.


Self Expanding Chart
Delete Obsolete Items From A Pivot Table-Excel 2007
What Are Pivot Tables- Create Your First One
Enable The DeveloperTab In Excel

Some Fun Stuff

Pivot Table Song

Popular Pages

  • Create A Date Time Stamp In Excel with VBA
  • Macro Mondays - Change All Pivot Table Filters At Once With A Macro
  • VBA
  • Macro Mondays - Running An Excel Macro From The Immediate Window
© howtoexcelatexcel.com. All rights reserved.
  • Privacy Policy