Is het possible to run a script that is constantly checking if a workbook is the only one in a instance?
If not to give a warning and set cell C2 is "Off"
I found this but it isn't working.
Please Login or Register to view this content.
Is het possible to run a script that is constantly checking if a workbook is the only one in a instance?
If not to give a warning and set cell C2 is "Off"
I found this but it isn't working.
Please Login or Register to view this content.
In cell C2 in THIS workbook?
Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
"isn't working" meaning what exactly?
Rory
you can put this macro in module, like:
then change Open event into :Please Login or Register to view this content.
and then you can run this macro manually (or set it to run every X minutes) to check that any other workbook has been open meantime.Please Login or Register to view this content.
If I am correctly read you needs.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks