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

Insert Multiple Worksheets With A Simple Excel Macro

February 22, 2021 by Barbara —Leave a Comment

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

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

How To Save Excel Worksheets As Separate PDF Files.

February 15, 2021 by Barbara —Leave a Comment

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

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

Macro Mondays – Running An Excel Macro From The Immediate Window

February 8, 2021 by Barbara —Leave a Comment

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

Filed Under: Blog, Excel Tip Category, Excel Tips& Tricks, Macro Mondays, Macros, VBA Tagged With: Excel Tips, Macros, VBA

Macro Mondays – How To Assign An Excel Macro To A Button Or Assign A Button To An Excel Macro

February 1, 2021 by Barbara —Leave a Comment

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

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

Password Protect An Individual Worksheet.

January 25, 2021 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...]

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

  • 1
  • 2
  • 3
  • …
  • 34
  • 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

Popular Pages

  • Home

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

Navigation

  • Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • Top Menu

Follow Us

  • Twitter
  • Facebook

Search

© howtoexcelatexcel.com. All rights reserved.

  • Privacy Policy