This code will count the number of cells on Sheet1 Range("A1:D4") that
have entries in them.

MsgBox WorksheetFunction.CountA(Sheets("Sheet1").Range("A 1:D4"))

x =WorksheetFunction.CountA(Sheets("Sheet1").Range(" A1:D4"))
If x = 16 then
msgbox "Sheet1 complete"
End if

You can do the same for the cells on any sheet.

this is pseudo code. (use the recorder to get the syntax you are looking
for.
Than set up an If....Then such that
If Sheet1 & Sheet2 complete then
Sheet3 unprotect
end if

Put the code in the ThisWorkbook module and use a sheet_change event.
Than every time a cell is changed - the code will run.

--
steveB

Remove "AYN" from email to respond
"Fillius Furral" wrote in message
...
My excuses if I was unclear, but I don't get what you explained.

I have a small table (4x4) on page 1. and a few open spaces on page 2 (A
bit
hard to explain, because it is a bit random, anyway...) I want the third
page
to be accessible, if that table on page 1 is filled in. It doesn't need to
make any sense, it just has to be filled. Then, on page two, if those
spaces
are filled in as well, I want page three to be opened, to check the given
answers.

So.. Table filled in on page 1, spaces filled in on page 2. Page 3 opened.

Thanks anyway, and thanks in advance. :) *takin' the easy way out*