Simple coding in Excel

[craigs]

I have created a series of forms which go from one to another via a macro,
which is simply:

Sheets("Implementation").Select
DialogSheets("Implementation").Show

(created by record macro).

There are two issues:

1. This same code does not work when assigned to auto_macro for the first
form?
2. After moving to subsequent forms, the previous forms are visible (but
not accessible) in the background. This just looks untidy and I would like a
command to close them.

Many thanks

[Bob]

Have you tried?

Sheets("Sheet Name").Visible = True
Sheets("Sheet Name2).Visible = False


"craigs" wrote:

> I have created a series of forms which go from one to another via a macro,
> which is simply:
>
> Sheets("Implementation").Select
> DialogSheets("Implementation").Show
>
> (created by record macro).
>
> There are two issues:
>
> 1. This same code does not work when assigned to auto_macro for the first
> form?
> 2. After moving to subsequent forms, the previous forms are visible (but
> not accessible) in the background. This just looks untidy and I would like a
> command to close them.
>
> Many thanks