Changing Sheet Using VBA Controls

[Schodoodles]

Hi,

Trying to make a 'Intro' sheet where the user clicks a button and it takes them to another sheet. This I have managed!
Only problem I noticed that it sometimes flicks half way down the sheet when I want it to start at the top.
The code I've been trying to use is,

Range.("Cell:Cell").Show

Can anyone sugest a better way?

Thanks!
Scho

 

[Norie]

How about something like this:

Sheets("MySheet").Range("A1").Activate

Change MySheet to the name of the sheet you want to go to.