Hi I was wondering if someone can help, I have created a Dashboard in excel 2007 when opened by an individual it takes about 45 seconds to open as it refreshes and brings in a lot of data from external databses. I need to provide a pop up message "Do you want to exit the Dahboard" and provide an option Yes or No when they close down the Dashboard ( by pressing X in top right). If some one can advise me how to do this using VBA or any other source it would be much appreciated.
Thankyou
Last edited by ZuneidDassu; 07-10-2014 at 11:20 AM.
Hi,
I just want to inform this is, if your process of retrieving data has been initiated, you cannot interrupt the code in between.
Regards,
Paresh J
Click on "* Add Reputation" as a way to say thanks
Hi Paresh
This is once the data has been received. It is a precautionary measure so the user is aware they are closing down the spreadsheet.
Regards
Zuneid
I found the following code which worked
Please Login or Register to view this content.
Zuneid,
I am looking to add something similar to a shared workbook; However, I don't think macros can be enabled in shared workbooks. How did you set yours up? Did you just insert a macro or was there also a control associated with it?
Thank you,
Rachael
Rachael all my code is put in either a module or under the Microsoft Excel Objects sheets
regards
Zuneid
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks