Password basics

MaximumGravity

New Member
Joined
Apr 16, 2002
Messages
29
I have done some searches on this site for password info. It is simple enough to password protect the whole book, but I am getting hit or miss info on the password protected sheet idea. I understand Excel passwords are lame at best, and maybe someone can ofer a better idea...

We have a workbook that is acting as an inventory log (of sorts) and we want to be able to use it as data entry, report generation and cost control/tracking. So far we can do the data entry and report features, I just can't think of a way to only allow admin users access to the cost side, while still showing an inventory listing with final retail costs on the other page. Since many users will be using this file, it would have to be able to either keep users from looking at the admin sheet, or else hiding the data until a password or something is entered.

I am open to sggestions to the possibilities of multiple workbooks, I am just limited in VBA, and still figuring out the complexities of Array formulas.

Any suggestions???

BTW, I have had no luck in "Protecting" a sheet. Maybe I am misunderstanding the concept of the "hide" feature, but I still end up with a mostly editable sheet, that is fully visible.

Thanks in advance,
Russell
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
These line will hide a worksheet:
sub HideWS()
Worksheets("Cost").Visible = False
end sub

The following lines will only unhide it if the password entered is correct:
Sub UnhideWS()
answer = InputBox("Input Admin Password")
If answer = "Your Password" Then Worksheets("Cost").Visible = True
end sub

You should assign UnhideWS() to a command button or something.

This method is very easy to break and doesn't provide a lot of protection to an advanced user.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,211
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top