Forum Discussion
VBA code for password to open excel
amitmahapatra similar to NikolinoDE I recommend showing a sheet upon opening but using that sheet to make sure the user knows that macros must be enabled and I would also put a button on that sheet to "Login". I would also recommend that you lock the macro project so people don't circumvent your macro/password.
Really thanks so much for all the help and its shaping into what i am looking for but little far off.. What you are proposing is to have 1 sheet with a button or something to ask for password .. but it allows to open the excel sheet.
But I am looking for password to be prompt when opening the excel sheet (through Macro or VBA) as attached the attached file...
Do you guys think that can be possible ?
amitmahapatra So I assume you know you can do this using built in Excel protection but it sounds like you specifically want a Macro solution. In the attached I modified NikolinoDE solution to hide the protected sheets. However, I keep 1 "public" sheet visible (hide all the other sheets) so you can prompt the user with information. It can be frustrating to a user that opens a locked workbook and sees nothing and no password prompt because of their security settings. I would also recommend locking the macro project but left it unlocked for you to work with easier. And if you insist you can delete/hide that public sheet also, I just don't recommend it.
Hi mtarler
yes you are correct. i know how to do it but i want it through macro to use same feature while opening from OneDrive in office365 web.
Now the the file i opened in my desktop. i got a warning to top ribbon asking "Enable Macro" and after i click that i did not got the prompt rather the way in attached screenshot. It has frozen the screen and nothing can be done. So i had to kill it by "Task Manager".
Then i had uploaded to OneDrive and tried to open it from there (that was my original requirement) .. so it has nothing. it did not ask for password at all. please find the screen shot attached.
amitmahapatra So the password window was tiny for some reason. you could actually still type in it and it would work but yeah that is a problem (4k monitor issues). As for drive, it doesn't let macros run. so if this is all about drive then that is a problem. In the attached I resized the password window but again I don't think this will solve you problem.
