Erich Duff
Board Regular
- Joined
- Apr 20, 2005
- Messages
- 129
All,
I doubt this can be done, but any input would be greatly appreciated.
A doorknob in my office just deleted an extremely important file. Luckily, we back up our server every night and I recovered yesterday's copy of it. However, this workbook is edited by three or four different people up to 20 or 30 times a day. So everything we've done today is lost and needs to be researched and entered again.
Is there a way to allow people to edit the book, but not actually delete it? And I'm talking, not be allowed to right-click-delete, that sort of thing.
I guess, failing that, the only thing I can think of is to create a BeforeClose event macro that will save a backup of the book every time it's closed. Whaddaya think?
Erich
I doubt this can be done, but any input would be greatly appreciated.
A doorknob in my office just deleted an extremely important file. Luckily, we back up our server every night and I recovered yesterday's copy of it. However, this workbook is edited by three or four different people up to 20 or 30 times a day. So everything we've done today is lost and needs to be researched and entered again.
Is there a way to allow people to edit the book, but not actually delete it? And I'm talking, not be allowed to right-click-delete, that sort of thing.
I guess, failing that, the only thing I can think of is to create a BeforeClose event macro that will save a backup of the book every time it's closed. Whaddaya think?
Erich