How to tell if multiple sheets are selected?
How can I tell if multiple sheets have been selected?
Thanks in advance Mike |
How to tell if multiple sheets are selected?
if activewindow.SelectedSheets.Count 1
"Mike Weaver" wrote: How can I tell if multiple sheets have been selected? Thanks in advance Mike |
How to tell if multiple sheets are selected?
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 |
How to tell if multiple sheets are selected?
I stepped through this code in the VBE in book2.xls with book1.xls active in
excel: Option Explicit Sub testme01() Debug.Print ActiveWindow.Caption End Sub I saw this in the immediate window: book1.xls Leith Ross wrote: 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 -- Dave Peterson |
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 |
All times are GMT +1. The time now is 11:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com