Failure to close DialogSheet

Hi everyone. I have a macro that pop's up a DialogSheet Box. It works fine,
but I'm trying to implement a button that would open a given worksheet and
close the DialogSheet Box. The worksheet opens, but the DialogSheet Box
remains. The line I wrote is:
DialogSheets("name").Hide

If I run the code in the Microsoft Visual Basic, run-time error 1004 occurs
(and I'm not being able to manage it - I already looked what it means, and I
just think everything is fine). If I try to run the code in Excel, this
message is displayed: "Your entry cannot be used. An integer or decimal
number may be required". Does anybody have any suggestions?

Thanks.

Hi

Guess your code errs before you reach the Hide row. Do you get a "Debug"
option with the error ? Choose that and it may take you to the problem.

HTH. Best wishes Harald

"Tiago C. C." <Tiago C. C.@discussions.microsoft.com> skrev i melding
news:9A7CE6E9-A972-44FF-B4B3-BA780AEA85EE@microsoft.com...
> Hi everyone. I have a macro that pop's up a DialogSheet Box. It works
fine,
> but I'm trying to implement a button that would open a given worksheet and
> close the DialogSheet Box. The worksheet opens, but the DialogSheet Box
> remains. The line I wrote is:
> DialogSheets("name").Hide
>
> If I run the code in the Microsoft Visual Basic, run-time error 1004
occurs
> (and I'm not being able to manage it - I already looked what it means, and
I
> just think everything is fine). If I try to run the code in Excel, this
> message is displayed: "Your entry cannot be used. An integer or decimal
> number may be required". Does anybody have any suggestions?
>
> Thanks.

Hi Harald,

Thank you for your reply. However, I had already checked the Debug option,
and it appointed the error was in the Hide line. Besides, the code in general
is huge and a lot more complex, and still everything else works fine, except
the dialog box that doesn't go away. My collegees at work agree the sintax
looks correct, and still nobody knows what's the problem.

Well, thanks anyway,
best regards,
Tiago.