| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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 |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
What do you mean by "close/exit sheet"
Regards, Peter T "count" <(E-Mail Removed)> wrote in message news:%23mrx7$(E-Mail Removed)... > 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 > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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 news:(E-Mail Removed)... > What do you mean by "close/exit sheet" > > Regards, > Peter T > > "count" <(E-Mail Removed)> wrote in message > news:%23mrx7$(E-Mail Removed)... >> 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 >> > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| exit form and close sheet | Doug | Microsoft Excel Programming | 3 | 28th May 2009 03:06 PM |
| RE: exit form and close sheet | Sam Wilson | Microsoft Excel Programming | 0 | 27th May 2009 05:20 PM |
| Close - Exit | SeaJay | Microsoft Word Document Management | 0 | 10th Dec 2005 01:45 PM |
| Close On Exit | Dave Dicken | Windows XP General | 4 | 19th Mar 2004 05:51 PM |
| Can't exit or close IE | Windows XP Internet Explorer | 0 | 23rd Oct 2003 12:04 PM | |
