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
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