Forgetting Worksheets are Grouped and Making Changes

[bmhumphries]

The answer may be "Just don't do that anymore", but I am wondering if there is a solution to this. It happened to me today, and now it just happened to a coworker.

When we print multiple sheets at the same time, I often select the tabs that I want to print and then print. What happens is that I run to the printer and when I come back after reviewing the print decide changes need to be made or further calculations.

So I get to work making changes, only to discover after a lot of work I still have multiple pages selected and the changes were made on all the sheets!

My question is, some setting in excel or some code one could add to an add-in that will warn you when you are making changes when multiple sheets are selected?

 

[schielrn]

You could use a worksheet selection change event for the workbook and put in this code maybe:

If activewindow.SelectedSheets.Count > 1 then msgbox "You have more than one sheet selected!"

Of course you would probably want to make it a little more elaborate than that, but I am afraid that if you work with more sheets selected more than just once, this would get very tedious and annoying. But I believe you would need to put this in each workbook for thiswrokbook code as I don't think you can make event code an add-in? Not positive on that though.