Forum Discussion
VBA code for password to open excel
For example when you open an Excel sheet by double clicking it, it will ask for enter the password and then only u can enter into this..
I know I can do that from file menu other way but I need only to get it done through VBA.
11 Replies
- As already, @mtarler informed you, the combination of password with VBA and Excel with OneDrive for Web is (to put it mildly) not the most suitable.Protect / Unprotect is a feature is something which is not supported by Onedrive. Currently, the only option is to download and then protect/unprotect and then reupload.As far as I know, but... what do I know :).
Workbooks that are protected (encrypted with password protection) cannot be viewed in a browser window or opened via Excel Online. And to open workbooks with password protection, we need to download them to the local PC and open them with Excel.
Here is an article for your reference: Workbook features that can differ between the browser and the desktop
Attached are the instructions for doing it yourself, where no worksheet can be seen, but is only for the entire workbook.Protect an Excel file - For do-it-yourself
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for MacTo prevent others from accessing data in your Excel files, protect your Excel file with a password.
Protect a worksheet
Excel for Microsoft 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007That was all I could give you in terms of information.
If you want to use VBA but with changes that you want, please simply give us a message.Thank you for your understanding and patience
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)
NikolinoDE and @mtarler .. thanks so much for all your help and time.
Here is a sample file to insert the password.
Have you fished from the Internet before long time not had more the side. I have used this example a few times with good results. You can of course make it even better.I hope to make some amends could 🙂
Hope I was able to help you.
Nikolino
I know I don't know anything (Socrates)
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 ?
- ups the same Person as before...sry dont see it.
VBA and macro scripting
You cannot create macros with VBA in Excel for the web, but you can open and edit VBA-enabled spreadsheets without removing (or corrupting) the VBA contained in the file. Learn more about getting started with macros.
You could use this code with other versions.
Only if it is your own file, otherwise you could be liable to prosecution.Hope I was able to help you.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here
- Hi.. I am looking for adding a password. I am not looking to remove.
If we can't use VBA, can you please help the piece of code that can be used to write a macro that can add a password to the excel.. A simple macro..
