Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there a macro/code that will warn me when multiple sheets are selected
when I open a file? A lot of my files have 10+ tabs with long names so I don't necessarily see all of the active tabs. So if I happened to save the file with multiple tabs selected and then reopen it and start working (without checking), I overwrite information I didn't intend to overwrite. I have seen the msgbox activewindow.selectedsheets.count code but I don't know where to put it in VB. Any help is appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pasting with multiple sheets selected loses undo history- why? | Excel Discussion (Misc queries) | |||
Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
How do I undo an action when multiple sheets are selected? | Excel Worksheet Functions | |||
message "Warning: Open source to update values..." | Links and Linking in Excel | |||
Multiple sheets selected | Excel Discussion (Misc queries) |