Disable protected mode OR remove the enable editing button of Microsoft Excel

No video

Disable protected mode OR remove the enable editing button of Microsoft Excel

Рет қаралды 32,048

5 жыл бұрын

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"****
KZfaq 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. TechForAll2019
Instagram: / techforall2019
LinkedIn: / techforall2019
Twitter: / techforall2019

Пікірлер: 9

@vivekrana5907 Жыл бұрын

thanks it works

@sagarmali6219 Жыл бұрын

Helpful❤

@spandanpate 3 жыл бұрын

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

@devajograna-xc4pw Жыл бұрын

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.