| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to tell if multiple sheets are selected?
Thanks. That gets me headed in the right direction.
Mike "Leith Ross" wrote in message ... Hello Mike, It is a good practice to preface Window operations with the application to which they belong. Functions like ActiveWindow are envrironmentally dependent. If you were troubleshooting your code in the VBA Editor, ActiveWindow would assume you are referring to the active window in the VBA Editor and not Excel. To prevent these problems qualify your object methods like this... Excel.ActiveWindow.SelectedSheets.Count Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=509245 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scroll Lock for selected multiple sheets | Excel Worksheet Functions | |||
| Warning Message (at open) if Multiple Sheets are Selected | Excel Discussion (Misc queries) | |||
| Pasting with multiple sheets selected loses undo history- why? | Excel Discussion (Misc queries) | |||
| How do I undo an action when multiple sheets are selected? | Excel Worksheet Functions | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
Threaded Mode
