Home

Excel Right-Click modifications

%3CLINGO-SUB%20id%3D%22lingo-sub-540474%22%20slang%3D%22en-US%22%3EExcel%20Right-Click%20modifications%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-540474%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20customer%20that%20received%20an%20protected%20Excel%20file%20from%20supplier.%20This%20file%20has%20protections%20and%20for%20example%2C%20it%20denies%20right-click%20actions%20in%20the%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%2C%20after%20this%20file%20is%20closed%2C%20these%20right-click%20restrictions%20are%20preserved%20in%20Excel%2C%20no%20matter%20what%20file%20you%20work%20with.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20that%20I%20can%20use%20Application.CommandBars(%22Cell%22).Reset%20to%20reset%20cell%20right-click%20to%20almost%20normal%20and%20also%20use%20Application.CommandBars(%22Cell%22).enabled%3Dtrue%20to%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20also%20use%20Application.CommandBars(%22Ply%22).Enabled%20%3D%20True%20to%20reset%20sheet%20tab%20right-click%20but%20I%20would%20like%20to%20know%20how%20can%20I%20reset%20all%20modifications%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20see%20what%20modifications%20has%20been%20applied%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20other%20controls%20does%20Application.CommandBars%20has%20besides%20%22Cell%22%20and%20%22Ply%22%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20reset%20all%20controls%20at%20once%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-540474%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ERight-Click%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-581255%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Right-Click%20modifications%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-581255%22%20slang%3D%22en-US%22%3E%3CP%3EAnybody%3F%20Anything%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Iivo Kerminen
Contributor

Hi

 

I have a customer that received an protected Excel file from supplier. This file has protections and for example, it denies right-click actions in the file.

 

But, after this file is closed, these right-click restrictions are preserved in Excel, no matter what file you work with.

 

I know that I can use Application.CommandBars("Cell").Reset to reset cell right-click to almost normal and also use Application.CommandBars("Cell").enabled=true to cell.

 

I can also use Application.CommandBars("Ply").Enabled = True to reset sheet tab right-click but I would like to know how can I reset all modifications?

 

How can I see what modifications has been applied?

 

What other controls does Application.CommandBars has besides "Cell" and "Ply"?

 

Is there a way to reset all controls at once?

1 Reply

Anybody? Anything??

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies