View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Edit DialogSheets


skrev i melding
...

I thought it was hidden also, but it just ain't there.

I can show the dialog sheet with this line of code
DialogSheets("FilterQuery").Show
but does not allow me into the design mode of the sheet.


Hi Herb

Try to run
DialogSheets("FilterQuery").Visible = True
and see if its sheet tab appear. Code will err if the workbook is protected,
but that password can be cracked easily if so and unknown.

HTH. Best wishes Harald