How to hide horizontal or vertical scroll bar using VBA Code in Excel ?

AbundantCode 3 weeks ago in Excel 1

Here’s a VBA code that hides the horizontal and vertical scroll bar in Microsoft Excel. How to hide horizontal or vertical scroll bar using VBA Code in Excel ? 1. Open the Microsoft Visual Basic for Applications Window using the ALT + F11 keyboard shortcut key. 2. Select Insert -> Module and then paste the following code snippet.

Displaying all the worksheet names in Excel using VBA Code

AbundantCode 3 weeks ago in Excel 0

Do you want to display the names of the worksheets in the excel workbook ?. Here;s how you can do it using the VBA Code. How to display all the worksheet names in Excel using VBA Code ? Open up the Microsoft Visual Basic for Application Window using the keyboard shortcut key “ALT + F11” and enter the following run and free F5 to run…

How to convert number to text in Excel?

AbundantCode 3 weeks ago in Excel 0

In Microsoft Excel 2016 , there are times when you don’t want the numbers present in the cell to be participating in the calculation. This means , you can either update the formula to not include the cell value or else change the number to text. How to convert number to text in Microsoft Excel 2016? You can use the TEXT function in Excel to…

Deleting all the hidden rows and columns in the active worksheet using VBA

AbundantCode 3 weeks ago in Excel 0

Do you want to delete all the hidden rows and columns in the active worksheet in Microsoft Excel using VBA ?. Here’s the code snippet that helps you to do it. How to delete all the hidden rows and columns in Active Worksheet using VBA in Microsoft Excel ?

How to hide the status bar in Microsoft Excel with the VBA Code?

AbundantCode 3 weeks ago in Excel 0

Do you want to hide the status bar in Microsoft Excel ?. You can use the VBA code to do it quickly. How to hide the status bar in Microsoft Excel with the VBA Code? 1. Open the excel workbook in Microsoft Excel 2016 and press the keyboard shortcut key “Alt + F11” to open the Microsoft Visual Basic for Applications window. 2. Click the…

How to change positive numbers to negative in Microsoft Excel 2016 ?

AbundantCode 3 weeks ago in Excel 0

Do you want to change the positive numbers to negative numbers and vice versa (or in simple terms) , reverse the sign of the numbers in Microsoft Excel 2016 ?. This blog post will provide you a simple tip on how to do it using the Paste special function. How to change positive numbers to negative in Microsoft Excel 2016 ? 1. Type the number…