Often users in my office select multiple sheets to print or for some other reason. Every once in a while someone will forget to ungroup the sheets before they start editing. This will cause the changes they make to happen in all the grouped sheets. This can corrupt the data in several sheets and waste a lot of time restoring them.
Is there a way I can have a message box or something pop up and tell the user they are about to edit a cell on multiple sheets? Thanks!
Haven't found a way to detect the array of sheets when the user first groups them, but this code will tell them what sheets changed after the fact. The only annoying thing is that it fires once for each sheet, and will fire for every change made.
Please Login or Register to view this content.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks