Forum Discussion
password protected excel in office 365
Hi Experts, I know that: "Excel for the web can’t open or edit workbooks protected by a password. In fact, passwords can’t be added, changed, removed, or recovered from Excel for the web. If yo...
Hi, yes you are right. I can do that in my own pc but not in office laptop because my company has blocked to download anything from One drive.. So I can update or upgrade anything in office laptop to work this...
The only way for me is to remove the normal password and have a VBA password encoded in the excel that will ask for password when open in office365 from one Drive on Web..
Can you please help with a code in VBA that can be used to ask for password when opening a Excel sheet? This is exactly what I need..
The only way for me is to remove the normal password and have a VBA password encoded in the excel that will ask for password when open in office365 from one Drive on Web..
Can you please help with a code in VBA that can be used to ask for password when opening a Excel sheet? This is exactly what I need..
My last thought is a manual solution so that you are also compliant with your company regulations. A USB stick from home with the files you want to edit at work and back at home with the stick to overwrite the existing files in your OneDrive.
It is tedious, but bypassing all possible regulations that are on your way. At the same time you are on the safe side that you are not breaking any company rules.
It's just a thought 🙂
It is tedious, but bypassing all possible regulations that are on your way. At the same time you are on the safe side that you are not breaking any company rules.
It's just a thought 🙂
Sorry that I took your time and couldn't give you a quick solution.
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)
- Sorry for misunderstanding me, didn't say you wanted to break the rules. I just said that you are on the safe side and that you can keep the rules safely.
Anyway, my mistake if it's gotten wrong.
Must improve my english to avoid misunderstandings.
I wish you a nice day and much success for a solution of your project.
Nikolino
I know I don't know anything (Socrates) - Thanks for your suggestions.. Really appreciate it..
Well I was not asking to break the rule rather i will follow the rule by not downloading it to desktop and still able to use password to open the file.. Anyways let's leave it..