Visual Basic for Automation (Macros Collection)
Workbook
Worksheets
- Sort all sheets
- Remove blank worksheets from Current workbook
- Color all Sheet Tabs
- Remove color from all sheet tabs
- Protect all worksheets
- Remove Password (Unprotect) all worksheets
- Insert ‘n’ number of Blank Worksheets
Range
Select
Number
Rows/Columns
Text
- Change Case (Upper, Lower, Proper, Sentence and Toggle)
- Remove Extra Spaces (Left, Right, Both sides and from Inside)
Format
Form
Event Macro
Miscellaneous
- Access Internet Explorer (Search Engine Example)
- Change Image Location
- Copy Excel Worksheets to MS Word
Leave a comment