View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PDX PDX is offline
external usenet poster
 
Posts: 2
Default xlDialogActivate to Select Sheets?


Is it possible to call the Sheet Dialog box (I think
xlDialogActivate) from VBA and allow the scrolling and
selection of sheets?

When I run Application.Dialogs(xlDialogActivate).Show it
show "open" files, I wished it to show Tabs similar to
when you right click on the "Tab Scroll Buttons"?

Thanks