View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
excelBI.com excelBI.com is offline
external usenet poster
 
Posts: 1
Default Selecting all sheets and sheet methods

DaveO plan seems good

Else create a hidden sheet

on Insert sheet event first activate hidden sheet, ensuring only one
sheet is activated