Simple coding in Excel

C

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
 
B

Bob

Have you tried?

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