Making sheets visible & hidden
Not sure why you are posting this in this thread, but see a possible
approach in response to your first posting.
--
Regards,
Tom Ogivy
"Xlyr" wrote in message
. uk...
Hey there,
I'm a HUGE novice with excel programming, through self-teaching I've
covered
quite a few simple commands but still there are loads to learn - yay.
Anyhoo, I want to be able to control what sheets some of my staff @ work
have access to.
I can easily make the tabs hidden, but unfortunately most of my staff
aren't
that simple!
What I have so far is a simple userform system which checks payroll
numbers
and passwords - and their access privilege...
What I want to be able to do is say... give level 1 users access to a
single
"staff" sheet...
Give level 2 users access to "staff" and "holiday" sheets...
give level 3 users access to "staff", "holiday" and "reports" sheets...
I am aware of the Visible, Hidden and VeryHidden variables for sheets -
how
to use them is the issue...
I keep coming up with ideas like...
If user_payroll.Value = Reference("PAYROLL1") Then
password_form.Show
Else
MsgBox("Payroll not recognised."), , "Oops!"
--------------------------------------------------------------------------
--------------------
If user_pass.Value = Reference("PASSWORD1") Then
Make Sheets("staff").Visible
Else
MsgBox("Password not recognised."), , "Oops!"
Then on logging out/closing the spreadsheet, the sheet(s) would become
VeryHidden again...
Any ideas how I can make this work - like I said I'm self taught and I
can't
find any good learning resources for this - the books I have on excel VBA
don't mention anything like this.
All input _WILL_ be greatly appreciated!
Also - any ideas on how I could instead create a similar system by using
an
excel spreadsheet as a database then taking all the login details from
there
would be excellent.
thanks,
Kai
|