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

preview_player
Показать описание
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.

*****Other Best Videos from "Tech For All"*****

*****Social Media Links*****
Рекомендации по теме
Комментарии
Автор

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.

devajograna-xcpw
Автор

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

spandanpate