Simple coding in Excel
 

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

Simple coding in Excel
 

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