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

Hi Herb

It should behave like any sheet, sheet tab and all. And fully supported in
2000.

Is it hidden ? Menu Format Sheets Unhide perhaps ?

Dialogs doesn't have their own modules. The associated code is in a standard
code module; Alt F11 or similar to get into the VB editor.

HTH. Best wishes Harald

"Herb" skrev i melding
...
I have an old spreadsheet that uses a DialogSheet. I can
show the sheet, (DialogSheets("FilterQuery").Show) but I
can't make changes to it. I need to get into the sheet to
remove a button, and to change the associated code for
another button. I am using Excel 2000, but the sheet was
created years ago.

Doea anyone know how I can do this?

........thanks in advance.......Herb