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

Cool. You're welcome Herb, thanks for the feedback.

Best wishes Harald

skrev i melding
...

That did it!!! Thank you, thank you..........Herb


-----Original Message-----

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


.