Move cursor to specified cell on next worksheet

I have some code that unhides the next worksheet when the value 'next' is selected at the bottom of the sheet being completed.

I would like to add some code so that the new sheet is opened and the curser is placed in the first cell that needs to be completed (E5) .

Grateful any help

Ed

Hi Carim,

Yes, it is always E5 - there are 7 sheets that may need completing, the next is unhidden on reaching the bottom of the active sheet, when the option to select 'next' appears through conditional formatting.

It would be user friendly if the next sheet could then become the active sheet and the user taken to the first cell that needs completing.

Ed

Hi Carim,

The unhiding is already fixed - you code does exactly what I wanted (after I pasted it to the right place!)

Many thanks - you've solved another of my problems - I think that's 3 beers I owe you now!

Ed

Hi Carim,

Oops, I think I may have bought you a beer too soon!

The next sheet opens OK but the cell select does not - I think it must have been coincidence when I first tested it - any suggestions?

Cut down version of code from sheet 'Service details' is below

Select Case sWord
Case "yes"
'True or false depends on how far through the book
Sheets("SP4 Summary").Visible = True
Sheets("Notes - read me").Visible = True
Sheets("service details").Visible = True
Sheets("property details 1").Visible = True
Sheets("property details 2").Visible = False
Sheets("property details 7").Visible = False
Sheets("Data 1").Visible = False
ActiveSheet.Next.Activate 'this works OK
Range("E5").Select ' this does not...??????

Case Else
.....etc


Regards

Ed

Ahhhh,

Activesheet.range - it makes all the difference

Thanks Carim, the beer account is incremented again

Ed