Forum Discussion
VBA code for password to open excel
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.