LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 161
Default Exiting a workbook

Hi all,

Nearly finished what for me is a fairly major piece of work and the last
thing I am doing is locking down the workbook so that users cannot
accidentally change anything they shouldn't.

So, under Vista on XL 2007, I have:
1) Password protected the VB work area (sorry - don't know what this is
correctly called). I am aware that XL password protection is not strong -
this doesn't matter as I am only protecting against casual/accidental damage,
not a conscious malicious attack;
2) Disabled right-click mouse functionality;
3) Turned off the ribbon.

Two questions:
1) Is there anything else I should do to prevent accidental corruption of
data (system backups, duplication etc. is already taking place)?
2) I want to be able to hide the "x" button that exits MS applications so
that users are forced to leave the workbook using my own exit button (this
allows me to automatically do some housekeeping before the application
closes). Is there any way of doing this - switching off the ribbon does not
seem to affect it?

TIA

Dave
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Message Box on exiting workbook cufc1210 Excel Discussion (Misc queries) 1 September 30th 09 02:39 PM
Re-establish function on exiting workbook Colin Hayes Excel Worksheet Functions 4 January 5th 09 02:55 PM
Unprotecting a Workbook before exiting iperlovsky Excel Programming 4 July 3rd 08 04:14 PM
Exiting a workbook Dick Kusleika Excel Programming 0 August 15th 03 05:30 PM
Exiting a workbook John Wilson Excel Programming 0 August 15th 03 04:43 PM


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"