Tags » Vba

[VBA] Excel ribbon - create custom tab (Office 2007+)


  1. Download tool Office Custom UI Editor http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2009/08/07/7293.aspx
  2. Download Office Icons Gallery https://www.microsoft.com/en-us/download/details.aspx?id=11675


  1. Write VBA code for all controls in target workbook (example code is provided at the bottom), Office Icons Gallery is used for looking up the names of the build-in icons used for the buttons;
  2. 450 more words

10 tips for better exploiting Excel

Originally posted in Linkedin on  April 13th, 2016

I was inspired by an article that I came across not long ago in Linkedin Pulse. It is said that almost all Excel users have not yet made the most of this application. 870 more words


How to save workbook using VBA

Below you will different ways of saving the excel workbook using VBA.

1.Save workbook with current date to specific folder

VBA Code:

Sub macro_save1()

‘Save a File with the current date: 187 more words


How to delete blank rows in excel using VBA

Delete Blank Rows

Below is the representation of data in Sheet1:

VBA Code:

Sub DeleteBlankRows()



End Sub

Final Output:


  1. Open an excel workbook…
  2. 35 more words

How to unhide all the sheets in excel using VBA

Unhide WorkSheets

 VBA Code:

Sub UnhideAllSheets()

‘Unhide all sheets in workbook.

Dim ws As Worksheet

For Each ws In ActiveWorkbook.Worksheets

ws.Visible = xlSheetVisible

Next ws… 42 more words


Get Property Syntax Bug [VBA]

I just saw this posted by @RubberduckVBA  on Twitter and couldn’t resist sharing it on here. Did you know that this VBA code will compile and run correctly? 50 more words

Microsoft Excel

Format Long String for VBA with Python

The following python script was useful when I had a long payload that I needed to add into a VBA macro.  It takes the string and then breaks it up into lines that can be added to the VBA.  127 more words