Forum Discussion

amitmahapatra's avatar
amitmahapatra
Copper Contributor
Nov 03, 2020

VBA code for password to open excel

Can anyone please help with a VBA code that can be used to ask for password when opening a Excel sheet? There can be a y no of sheets in the work book but none can be accessed if password is wrong.. ...
Excel for web
amitmahapatra's avatar
amitmahapatra
Copper Contributor
Nov 03, 2020

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. 

mtarler's avatar
mtarler
Silver Contributor
Nov 03, 2020

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.