Hide/Unhide with passwortd prompt

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Duggan - 23 Jan 2006 20:48 GMT

I'm working on a spreadsheet for my employer that has a number of sheets
that need to be hidden from some users, but visible to others (e.g. costs).
All users need to be abler to make changes, but only some will see ceratin
areas.

The restricted users are mobile sales people working with laptops.

The workbook is currently set up with all sheets but one hidden and I am
using command buttons with macros to navigate in the workbook and
hide/unhide the sheets.

How can I set this so that users' are prompted for a password when they want
to access certain areas.

Thanks

DRD

Reply to this Message

ben - 23 Jan 2006 22:54 GMT

you could have an input box pop up when they want to access the sheets, with
a password specified in code, or a userform with a 'masked' textbox
(neither really secure)

sub commandbutton1_click()
select case inputbox("Please enterpassword","Password")
case "mypassword"
code to show hidden sheet
case else
msgbox "I'm sorry that is an incorrect password"
exit sub
end select
end sub

Signature

When you lose your mind, you free your life.

> I'm working on a spreadsheet for my employer that has a number of sheets
> that need to be hidden from some users, but visible to others (e.g. costs).
[quoted text clipped - 13 lines]
>
> DRD

Reply to this Message

David Duggan - 24 Jan 2006 00:06 GMT

This works except for the fact that the password appears in the Input Box in
clear text rather using characters such as asteriks. I have a form built
that works, except that I would need a number of forms for this
spreadsheet.

If I could declare a variable and then use the variable to call a specific
macro, I can build all my requirements into one form. That's where I am
right now, but I'm having problems with it. Maybe just syntax, I don't know.

Thanks for the help.

DRD

> you could have an input box pop up when they want to access the sheets,
> with
[quoted text clipped - 31 lines]
>>
>> DRD

Reply to this Message