saint_2008

Board Regular
Joined
Sep 6, 2007
Messages
101
My self and a group of people are using a shared workbook, But not everyone is great with computers that use this work book and if a popup appears they normally just say ok with out actually thinking about what it says!

The problem is when people are saving there overwriting other peoples work in excel with “accept my changes” rather than do accept other persons changes and move theirs to another blank cell that’s free.

Is there a VB/Macro that can solve this something that can detect when you save and if it knows it’s going to overwrite it will automatic move it to the next blank cell, then save it self. To avoided overwriting someone else’s hard work!

Or does anyone know of other options that may help to prevent this, I’ve tried putting the auto save time down but with it a large workbook it spends more time saving so wasn’t too particle.

Many Thanks for any help, support and Ideas how to resolve this annoying issue. :)
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Watch MrExcel Video

Forum statistics

Threads
1,108,918
Messages
5,525,624
Members
409,657
Latest member
19JimRon72

This Week's Hot Topics

Top