Hello all, I have created a spreadsheet and wanted to originally see if I could save as a separate format (that makes it more like an application than an Excel spreadsheet). Having investigated, I found that full screen mode pretty much does what I want, however you can restore the menus by pressing ESC or selecting restore down. Is there a way of preventing users from exiting full screen mode, I could add a close application button for them to use instead. Thanks in advance.
There is code at this URL to do just what you are asking as far as I interpret your question
http://www.mrexcel.com/forum/excel-q...-workbook.html
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks for the response. The thread you showed has the code I need to hide, disable menus, however what I'm really after is to do that and prevent users from exiting full screen mode e.g. not being able to simply press ESC or select restore down to retrieve Excel's menus. Please let me know if I'm not making any sense, thanks.
I suggest that you present this problem in the VBA forum as that is where the VBA experts "hang out". Contact one of the moderators of this forum and ask if the thread can be moved to the VBA area.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks