View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Multiple Worksheet Selection

Something like this...

MsgBox ActiveWindow.SelectedSheets.Count
--
HTH...

Jim Thomlinson


"Peter-d" wrote:

Is there a way out there to figure out from VB code if more than one
worksheet is selected?

Thanks