Excel VBA

Learn to Pro Excel VBA Tip and Tricks and Download Codes and Workbooks

Unprotect Specific Worksheet while opening Workbook
Unprotect Specific Worksheet while opening Workbook
Learn how to protect a worksheet on workbook close This is very important when you find that you’re constantly protecting and unprotecting worksheets before distributing your workbooks How it works (Protect a Worksheet on Workbook Close) This code is triggered by the workbook’s BeforeClose event.  When you try to close the workbook, this event fires, …
This macro is an best way to protect users from accidentally closing their file before saving You can Force excel to save workbook before closing using Excel VBA Code in at workbook level If you are dealing with very sensitive data where information is really important and workbook you are using for this purpose is …
How to Save Excel Workbook on a Cell or Range Change using Excel VBA(download workbook) Table of Contents When its important to save workbook on Cell Changes?  If you are dealing with very sensitive data where information is really important and workbook you are using for this purpose is well protected, then you can try …
Create or Add a New Workbook using Excel VBA In your routine workflow, you often come across situations where  you want or need to create a new workbook in an automated way, and only way to get this done is creating the New Workbook using Excel VBA For instance, you might want  to copy data …