Learn VBA to unhide all sheets in a Excel workbook. This code sets visibility property of sheet to unhide even the very hidden sheets.
VBA Userform – Escape key to Close – Unload form
Learn how to close a vba userform with escape key. Map command button to Exit or Close a Userform with Escape key.
VBA to open or save Word document Protected or Encrypted with password
Use this VBA code to password protect or unprotect the Word document while openening the file. This macro also handles readonly protection, Write protection etc., right within the code itself.
VBA Get Numbers with in a String
Excel VBA code to get all digits or numbers with a string. This function extract only the numbers from with in a string text.
2022 Holiday List – India Vacation Planner
2022 Holiday list for india with vacation planner details that would help you get the long vacation details along with other national holidays.
List of Holidays 2022 – USA Vacation Planner
Get the list of holidays 2022 aong with dates, days & also which one are coming up in long weekends. Plan vacation with this holiday list 2022
How to remove Signature from Outlook Email using VBA code?
Get the Outlook vba code to remove the signature from a email that was autoamtically created within the macro. It is usefull when you add custom signature.
VBA – Find number of Dimensions in an Array
How to find the dimensions in an array using Excel vba code? Here is the code to cound the array dimensions using the ubound function – tricky one.