Hi Guys,
i would like to break macro when user will press special combination of keybord like ctrl +t .
It is possible?
How can i do this?
Now i am refreshin power query table when workbook is closed - it is taking not a little time so i want to give user possiblity to break calculation and exit in normal way.
How to do this?
Please save with some examples,
Jacek
Hi,
the normal way to stop or break a macro is the shortcut CTRL+Break(Pause)
Greetings
Tor
thanks i know this method but i am getting error because i am interrupting pwoer qweury refresh:
Screenshot_30.png
Jacek
I guess that the code for refresh is in the Workbook_BeforeClose event then?
I do not see any other possibility to break the code here. But what i could offer you is, to ask the user if he/she wants to cancel the refresh on closing. then the user can press ESC and the workbook will close without running the refresh. Only they have just to confirm that they really want to stop the refresh.
Just try it:
Please Login or Register to view this content.Please Login or Register to view this content.
thank you very much. This is very nice!
can i replace Application.EnableCancelKey = xlErrorHandler with other button like "ctrl + t" or not?
Jacek
It is not possible to use other key combinations?
Jacek
Anyone can confirm that it not possible to use specific keybord buttons?
Jacek
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks