to setup A "Logon" Password restriction to View Da

cyote101

Active Member
Joined
Dec 11, 2004
Messages
315
Is ther a way to have a speed sheet and useing Marcos to allow or restric action dependent on typing in a password.

example: I use spreedsheets every were. I make Beutif ones. for all area's I work in. I find it very easy to understand to get it to do what I want. but I'm still learning.

I have some data That I only want sertain people to see. I make it so all of the Sheet Tabs are not visable and nuthing but the menu is visable. I wasnt to make a login module for Excel.

It does not in actuality need to be hack proof as the people who are going to use it are not Pros but I want to make it idiot proof.

That's the Idea.

If you have any Idea's Let me know
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
You could create a userform that appears when the spreadsheet is activated.

It could have a textbox for the user to input a password and a commandbutton that has code that checks the password.

BTW this post should probably be in the Excel forum.
 
Upvote 0

Forum statistics

Threads
1,221,831
Messages
6,162,252
Members
451,757
Latest member
iours

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