VBA

Macros

Password protect viewing a sheet

 

Modules

Sending emails (without using email application)

Multiple Find and Replaces

Refresh one connection at a time

 

Workbook Code

Go back to last active sheet

Show / Hide Sheet Tabs

 

Worksheet Code

Auto scroll sheets back to top left

Stop Worksheet Activate code running

Very Hidden worksheets

Find the last row or column

 

Application functions

Play audio / sounds

 

Click Events

Chart events

Check day or time

Check if multiple cells selected

 

General

Protecting your VBA modules