Excel Add-In To Perform Common Tasks

Category:
Office/VBA
Type:
Applications
Difficulty:
Intermediate
Author:
Jon Cogzell

Version Compatibility: Visual Basic 6, Visual Basic 5

More information:
I regularly do common tasks in excel which required some VB(A) code. I decided to write an add-in for them. Tasks the add-in peforms include:
  • Deleting blank columns
  • Deleting columns where selected rows are blank
  • Deleting blank rows
  • Deleting rows where selected columns are blank
  • Append running totals to a row or column
  • Set or change a workbook password
  • Many more

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download spreadsheet_solutions.zip