How to Restrict Multiple Instance of VBA?
VBA VBAPosted by admin on 2022-11-02 18:30:00 |
Share: Facebook | Twitter | Whatsapp | Linkedin Visits: 1236
At times we set/reset registry settings/environment variables as part of the program logic. If another instance of the application uses this concurrently it would become a mess. The best is to prevent the application from being loaded for the second time. The easy way to do is to use App.PrevInstance method as shown below.
If App.PrevInstance = True Then
MsgBox “An instance of this tool is running in this machine! Requested instance will be terminated”, vbExclamation
Exit Sub End If Find out Upcoming Excel VBA Batch nearby to learn VB Coding and automate your routine Excel Reports, processes and tasks with ease.
WWW.ScriptsKart.com
Search
Recent Blogs
- How to Restrict Multiple Instance of VBA?
- Important Shortcuts for Excel VBA
- VBA Code to Highlight Named Ranges
- VBA Code to Highlight Cells with Misspelled Words
- VBA code to Highlight all the Blank Cells Invisible Space
- VBA code to Highlight Unique Values
- VBA Code to Hide all but the Active Worksheet
- VBA Code to Unhide all Hidden Worksheets
Leave a Comment:
