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