Excel
Determine the File Path or GUID to a VBA Reference Library
Ken Puls
05/09/2009
Check if Worksheet is protected
Remove Missing VBA Library References via code
Select specific range when specific worksheet is activated
Select specific range on any worksheet that is activated
Close the workbook with or without saving
Remove all cell formatting - Retaining fonts
Remove all cell formating and styles, and restore default font
Adjust range to exclude irrelevant cells
Unprotect all colored cells only
Eliminate excess spaces from selection
3 ways to put a cell value in a page header
Use Toggle Button To Hide And Unhide Rows
05/08/2009
Identify Selected Item in a single selection Listbox
Email active worksheet using Outlook
Identify Selected Item in a multi selection Listbox
Test procedure run time
Multiple Apps
Push Excel Named Range Values to Bookmarks in Word
Function to return various Environment Names
05/06/2009
Create Hyperlinked List of Directory Contents
Create List of Hyperlinks From Selection
Ensure that cell A1 on a specific sheet is selected when workbook is opened
Disable Cut, Copy, Paste
Force users to enable macros in a workbook
Hide or unhide worksheets
Please read our Legal Information and Privacy Policy Copyright? 2004 - 2005 VBA Express