I´d like to add macro into autoclosing workbook.
I have autoclosing workbook after certain time of inactivity and I´m not able to run automatically my macro before closing this workbook.
Any ideas?
thanx a lot
I´d like to add macro into autoclosing workbook.
I have autoclosing workbook after certain time of inactivity and I´m not able to run automatically my macro before closing this workbook.
Any ideas?
thanx a lot
Hi Keepermokrad,
In the "ThisWorkbook" VB module, you can create a BeforeClose event to do what you need.
Please Login or Register to view this content.
You can use the before close event:
Please Login or Register to view this content.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
I have this one (macros name is skusocka)Please Login or Register to view this content.
Last edited by keepermokrad; 11-19-2011 at 06:02 AM.
macros name is "skusocka"
Please Login or Register to view this content.
Last edited by keepermokrad; 11-19-2011 at 06:02 AM.
have added two ways , but not working neither
Post the code for Disable and skusocka.
I would like to add macro SKUSOCKA before macro on the bottom.
Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks