Disable protected mode OR remove the enable editing button of Microsoft Excel
Вставка
- Опубліковано 26 сер 2024
- How to disable the protected mode of Microsoft Excel?
How to remove the enable editing button in Microsoft Excel?
"PROTECTED VIEW: Be careful - email attachments can contain viruses. Unless you need to edit, it's safer to stay in Protected View."
Steps:
1- Open any Excel file
2- Click on File
3- Click on Options
4- In Excel Options click on Trust Center
5- Click on Trust Center Settings button
6- Navigate to the Protected View menu
7- Remove the tick of the last option (Enable Protected View for Outlook attachments.)
8- Click OK twice
9- You are all good :)
For more interesting videos on new technology and if you want to find out the best solution for your day-to-day tech problems then subscribe to my channel.
Tech For All: bit.ly/392sEu9
****Other Best Videos from "Tech For All"****
UA-cam Tips & Tricks: bit.ly/31hVQaI
Different Types of Wireless Routers' Configuration: bit.ly/2yE5c4y
Windows Server 2008 R2 Tutorial: bit.ly/2YDmDwE
****Social Media Links****
Facebook: www. Tec...
Instagram: / techforall2019
LinkedIn: / techforall2019
Twitter: / techforall2019
Awesome information.but I'm having issues with excel VBA. I sent a worksheet with custom VBA attached to an email. Once the user downloads the file, it open in excel in "protected view" and a button "enable editing" is shown. Once that is clicked, all the VBA code is deleted. Is there anyway to get around this? Hoping to be favoured.
In my case My file - option (is off/grey)
Also
On excel sheet (workbook) i am not able to edit i am not getting option for enable protection wordpa d also same
I can view my graphs Nd table and all values
Can it be so brcause
I am now doing work in flight mode
Is internet connection mandatory to be able to edit
I use microsoft 2019 in my laptop
thanks it works
Helpful❤
Not working
Dear Payal
Can you give me remote access. I will try to solve the issue for you.
o great
thanks Islam Jan for the suppot
Already unmark