Failure to close DialogSheet

[Tiago C. C.]

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.

 

[Harald Staff]

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.]

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.