Posts by sekrup

Re: Display Print Password As "*"

It work !!
thank you very much for your help, now my problem solved.

Dear all,
how to set display password into "*", so when input password others can not read.

Thanks

Re: File Protection With Vba

sorry, wrong file

Re: File Protection With Vba

here my workbook
thanks a lot

Re: Excel VBA: Creating a Login Box

sorry, i've re-read it...

Re: File Protection With Vba

Sorry for my bad english, i can't describe what i mean.
i use excel to store my data and i want to use login box to restrict user to open,copy and print. but if macro disabled, user still can access the data.
so, i search codes that force macro enable, create login box, prevent copy, cut and print and try to combine it.
because i don't know about vba, now the codes doesn't work.
i can't update password at login box, and many error when open the file.
i have no idea how to make it work.

Re: Excel VBA: Creating a Login Box

Hi there,

i have read your code about Excel VBA: Creating a Login Box and try to use it. but i have problem to update the password. after input new password and then click update password, pasword updated.
but appear msg box : must use this form...... then file closed and password not updated.
yesterday this code running well.
can you help me to solve this problem ?

Re: File Protection With Vba

thanks for your suggests.
i know nothing about vba. i have to make more simple about this protection,maybe without login password

Re: File Protection With Vba

I mean, if macro disable, only blank sheet is appear and the others are verry hidden. But if macro enable, sheets that contain data are enable, and others verry hidden.

Dear all,
I need to protect excel file. I have search vba codes and tried to combine :
1. Must enable macro on open
2. Input user id and password
3. Disable cut, copy, paste and print
but not work.
user : test
password : 1
Details as per attachment
Please suggest...