If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Exit via macro only?
Hello out there. Is it possible to 'force' a user to exit a spreadsheet only via a macro? i.e. is it possible to disable the "Close" command but activate it again in their setup after they've exited the spreadsheet in question? Rob -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=475774 |
#2
|
|||
|
|||
It's "sort of" possible in a theoretical way -- you remove the menu options
and trap the commands -- but it never really works in practice, and you can't actually *force* the user as such. There are always ways around it (most obviously, by disabling macros). Don't go there. Come up with another design for your application. "Brisbane Rob" wrote in message news:Brisbane.Rob.1wuamd_1129205106.2044@excelforu m-nospam.com... Hello out there. Is it possible to 'force' a user to exit a spreadsheet only via a macro? i.e. is it possible to disable the "Close" command but activate it again in their setup after they've exited the spreadsheet in question? Rob -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=475774 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro: Exit active workbook without save? | Param | Worksheet Functions | 3 | May 20th, 2005 06:47 AM |
Copy cell format to cell on another worksht and update automatical | kevinm | Worksheet Functions | 21 | May 19th, 2005 11:07 AM |
Recordset Source in VB | str8trini | General Discussion | 9 | January 11th, 2005 11:20 PM |
Keyboard Shortcut Only Runs Part of the Macro | Jonnyboy117 | General Discussion | 2 | July 14th, 2004 08:27 PM |
re; Worksheet_SelectionChange goes cold | Rob | General Discussion | 1 | June 12th, 2004 01:43 AM |