Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
[Fwd: Run macro on exit worksheet/workbook] | Excel Discussion (Misc queries) | |||
Run macro on exit worksheet/workbook | Excel Worksheet Functions | |||
Macro: Exit active workbook without save? | Excel Worksheet Functions | |||
on exit macro | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |