Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ecape key to close/exit sheet
Hi,
I need to give users consistent interface experience :) So I'd like to have Something on a worksheet (or chartsheet) that would react to Escape key - like CommandButtons do on forms, if their Property Cancel=True. I use them on all forms and users love it. This Something can be Anything: ActiveX, Custom class objects, Accelerator tricks... Custom class objects would be best, as they hold Code in Class modules (and not with data-laden worksheets). Wishing you inspired moments, :) Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ecape key to close/exit sheet
What do you mean by "close/exit sheet"
Regards, Peter T "count" wrote in message ... Hi, I need to give users consistent interface experience :) So I'd like to have Something on a worksheet (or chartsheet) that would react to Escape key - like CommandButtons do on forms, if their Property Cancel=True. I use them on all forms and users love it. This Something can be Anything: ActiveX, Custom class objects, Accelerator tricks... Custom class objects would be best, as they hold Code in Class modules (and not with data-laden worksheets). Wishing you inspired moments, :) Paul |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ecape key to close/exit sheet
You are right - question was unclear, apologies.
I meant switching to another sheet - predefined, say MenuSheet. Environ. Excel 2003 Regards, Paul Użytkownik "Peter T" <peter_t@discussions napisał w wiadomo¶ci ... What do you mean by "close/exit sheet" Regards, Peter T "count" wrote in message ... Hi, I need to give users consistent interface experience :) So I'd like to have Something on a worksheet (or chartsheet) that would react to Escape key - like CommandButtons do on forms, if their Property Cancel=True. I use them on all forms and users love it. This Something can be Anything: ActiveX, Custom class objects, Accelerator tricks... Custom class objects would be best, as they hold Code in Class modules (and not with data-laden worksheets). Wishing you inspired moments, :) Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Close vs. Exit in 2007 | Excel Discussion (Misc queries) | |||
Close UserForm despite Exit Event | Excel Programming | |||
Close and Exit Excel | Excel Programming | |||
Close and Exit Excel | Excel Programming | |||
Close or Exit application | Excel Programming |