Thread: How to tell if multiple sheets are selected?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_536_] Leith Ross[_536_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote