by Ilker | Aug 31, 2020 | Excel Tips & Tricks
You can easily copy sheets in Excel manually with a few simple mouse clicks. On the other hand, you need a macro if you want to automate this process. In this guide, we’re going to show you how to copy sheets in Excel with VBA. Download Workbook Before you start...
by Ilker | May 28, 2020 | Excel Tips & Tricks
Workbook_Open and Auto_Open are two predefined events for Excel VBA. Both events allow you to run a macro right after the workbook is loaded. You may want to open the workbook without triggering anything in some cases – either to skip a certain code block for...
by Ilker | May 27, 2020 | Excel Tips & Tricks
You may want to set an expiration date for a workbook and prevent access for when creating a trial application, or simply ensuring that the application data is up to date. Unfortunately, Excel doesn’t have a built-in tools to handle this scenario, but you can use VBA...
by Ilker | Feb 26, 2020 | Excel Tips & Tricks
Excel’s toolbar and Ribbon contain many features and shortcut icons that are aimed for improving productivity. On the other hand, these icons actually take a lot of space in your screen. Thus, your work space becomes a bit more limited. A full screen, or...
by Ilker | Feb 26, 2020 | Excel Tips & Tricks
By default, the formula bar is visible in Excel to allow you to see and enter formulas in the active cell. However, you may want to hide the formula bar either to limit user interaction with it, or to give your Excel workbook a compact look and feel. Alternatively,...
by Ilker | Feb 25, 2020 | Excel Tips & Tricks
As you might know, Excel displays horizontal and vertical scroll bars to allow scrolling through the horizontal and vertical areas in worksheets. Although, these are essential tools for working in a workbook; you may want to hide them to give your Excel workbook a...
by Ilker | Nov 21, 2019 | Excel Tips & Tricks
A loop is an essential concept for any programming language, and VBA follows the same approach. You can use loops to repeat an action until a specified condition is reached, or move through objects in a group, e.g. all worksheets in a workbook. A loop is an essential...
by Ilker | Jul 2, 2019 | Excel Macros, Excel Tips & Tricks
Macros in Excel are code blocks that you can run in your workbooks to process a batch of commands. Macros are great for automating repetitive tasks such as copying or removing data from specific cells. However, macros can be daunting for new users. Creating a macro is...
by Ilker | Jun 28, 2019 | Excel Tips & Tricks
The Excel Developer tab is a Ribbon tab which contains a number of tools aimed towards advanced features of Excel such as VBA, add-ins, form and ActiveX controls. Although you can access the VBA Editor with the shortcut (Alt+F11), the Developer tab in the Ribbon also...