paul_t_morris
New Member
- Joined
- Sep 17, 2002
- Messages
- 4
Hi everyone,
We have a spreadsheet in work that all of our staff use. To limit the mistakes the staff can make (messing up the spreadsheet!) we have put in some safety measures. When it's opened it goes to full screen, loses the toolbars (to stop them cutting and pasting etc...!) but I need to do something else aswell.
Is it possible to have a macro run/message box when they try to close the workbook using the cross in the top left.
We don't want them to do this because next time they open excel it opens in full screen.
Any help will be appreciated!
Paul Morris
We have a spreadsheet in work that all of our staff use. To limit the mistakes the staff can make (messing up the spreadsheet!) we have put in some safety measures. When it's opened it goes to full screen, loses the toolbars (to stop them cutting and pasting etc...!) but I need to do something else aswell.
Is it possible to have a macro run/message box when they try to close the workbook using the cross in the top left.
We don't want them to do this because next time they open excel it opens in full screen.
Any help will be appreciated!
Paul Morris