View Single Post
  #2  
Old October 13th, 2005, 01:16 PM
Jezebel
external usenet poster
 
Posts: n/a
Default

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