show is a method relevant for a userform. Use the activate method for
sheets eg

thisworkbook.sheets("?????").activate

--
Cheers
Nigel



"kirsten" wrote in message
...
I am trying to let the dialoguesheet "?????" show while i initialize my
VBA
Micro,the vba code is as follow:
thisworkbook.sheets("?????").show
when i run the code, the window tell me error code '1004' and class
dialoguesheets's show method invalid.
could anyone help me with the problem? thanks