If you create the new form as a template and save it with the cell you want
it to be started with as the active cell - delete any inactive sheets from
the template. You could then use the following code in the click event of
your command button:

Sheets.Add Type:= "Filepath\Filename.xlt"

One thing to be aware of on this is that if you have named ranges within
your templates these will cause a warning message so it is best if these are
removed.

Hth

Jon


"kassie" wrote in message
...
Do you want to move to another (existing) sheet, or do you want to create
a
new sheet when you click on this button?
--
Hth

Kassie Kasselman
Change xxx to hotmail


"Sonya" wrote:

I am not so much of a new user, but use Excel so infrequently that I
usually
spend an entire day re-learning everything. I am using Excel 2002.

My client is requesting I create a form in Excel. Everything was going
well
until I get to the request where they want some sort of button or
something
that will allow them to click it and automatically be taken to a new form
(work sheet) if they click it. I am thinking it should go to the first
cell
enterable cell in the new worksheet.

Any suggestions? Is this even possible?