Methods to save a Macro FREE copy of a workbook [FREE DOWNLOAD]

Dear Friends, This is a very simple yet powerful Excel VBA tip for you. Many a times before sending your workbook with Excel VBA Macro code in it, you want to save your workbook without any VBA code in it. Therefore here in this article, I will show you - how to save your Excel Workbook without excel macro in [...]

40 Useful Excel Macro [VBA] examples – Part 2 of 2 [ FREE DOWNLOAD ]

Dear friends, As you see this is the second and last part of the tutorial 40 Useful Excel Macro [VBA] examples. In previous article i had published the first 20 examples. Download a FREE Excel Workbook with all 40 Examples At the end of this article, you will have a link to download a FREE copy of all 40 useful [...]

[VIDEO] Excel VBA Tip – Hide Horizontal scroll bar in Excel

Dear Readers, Every week, I am going to publish at least one Excel VBA Tip where I will be sharing some small code snippets, tips, tricks which will be useful for you during development of any Excel VBA tool. YouTube Channel You can subscribe to LearnExcelMacro.com Channel where all the videos are going to be uploaded. You will be notified [...]

Macro to Copy from Excel in to Word Document

In Previous Article we saw how to Copy Content from a Word Document and Paste in in to the Active Workbook. Now in this Article i am going to write a function will Select a Range from Excel and paste the content in a New Word Document. Here there are two possible way of copying and pasting in Word Document. [...]

By |Categories: Excel Macro|Tags: , |6 Comments

How to Copy content from Word using VBA

As many of us want to deal with Microsoft Word Document from Excel Macro/VBA. I am going to write few articles about Word from Excel Macro. This is the first article which opens a Word Document and read the whole content of that Word Document and put it in the Active Worksheet in a particular Cell. Opening an Word Document [...]

By |Categories: Excel Macro|Tags: , |6 Comments

Excel Macro Tutorial : VBA Spin Button

In the previous Article How to write Excel Macro - Your First Excel Macro of Excel Macro Tutorial, you have seen how to write Excel Macro. Also in Previous Tutorials, you have seen all the basic concept of Excel Macro. In this Article I am going to show you how to Add and Use Spin Button. Spin Button: Spin button [...]

How to Disable Right Click in Excel Workbook

Some times for some security reason or some other reason, you want to disable right click on the Workbook or Worksheet or on a particular Cell or Cell Range. 1. Disable Right Click on Whole Workbook 2. Disable Right Click on whole WorkSheet 3. Disable Right Click on a Cell or Cell Range 1. Disable Right Click on Whole Workbook [...]