View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
craigs
 
Posts: n/a
Default 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