Thanks for the reply.

New to Excel VB, was hoping someone could point at some examples tha
could be adapted to suit. Especially the lookup of the user name an
returning the permission value.
Have done something similar with MS Access and a tab control, a
below.

- Private Sub Form_Open(Cancel As Integer)


Dim ChooseSecure As Integer

ChooseSecure = DLookup("Edit_Secure", "Staff", "Staff_Name
UserLogin()")

Select Case ChooseSecure
Case 1
TabCtl261.Pages(0).Visible = True
TabCtl261.Pages(1).Visible = True

Case 2
TabCtl261.Pages(0).Visible = True
TabCtl261.Pages(1).Visible = False

End Select

End Sub-

Any help with the equivalent 'ChooseSecure' lookup appreciated.

TIA

Maxwel

--
Message posted from http://www.ExcelForum.com