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

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