Hi,

First we need to get some terminology correct. Your workbook has worksheets
and worksheets have sheet tabs that contain the name and allow some other
limited functionality.Data are entered into worksheets not tabs so your
question seems to be can you ensure the correct fields are filled in on a
worksheet before the user moves onto the next worksheet.

You can do that and it requires macros and there you hit your first obstacle
in that how do you make users enable macros and I suggest you search these
forums for the answer to that but on the assumption you overcome that here's
a way to do what you want.

First make the required worksheet active:-
Alt + f11 to open VB editor. Double click 'This workbook' and paste this in.

Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Sheet1").Select
End Sub

Then double click 'Sheet1' and paste this in

Private Sub Worksheet_Deactivate()
myvalue = 1
If Range("A1").Value < myvalue Then
MsgBox "You must fill in A1 before leaving this sheet"
Worksheets("Sheet1").Select
End If
End Sub

This requires the user to put a 1 in a1 or they are redirected back to
sheet1. You will have to set up yourself what values and where you want
populated.

Mike

"OrlaLynch" wrote:

I am trying to control the way my users use my worksheet. I have several tabs
in my worksheet. I am trying to block the user from using the next tab unless
they enter data into certain cells. These cells cannot by empty to move onto
the next tab. I don't know if this is possible as i cannot find this anywhere
on the website.

Thank you for your help.
Orla