a big problem after run macro in exel

[abdelfattah]

hello
i have a big problem when i tested this code type of protection it hide command bar when i right click does not show but when i change to true it also doesn't change it supposes showing the menu when right click
this is the macro

Sub cc()
  Application.CommandBars("Worksheet Menu Bar").Enabled = false

End Sub

thanks

thanks

 

[Logit]

Option Explicit

Sub disable()
'This code line will disable the Cell menu (menu what you see when you right click on a cell/range)
Application.CommandBars("Cell").Enabled = False
End Sub

Sub enable()
'This code line will disable the Cell menu (menu what you see when you right click on a cell/range)
Application.CommandBars("Cell").Enabled = True
End Sub

Download example workbook : Rt Click Disable.xlsm

 

[abdelfattah]

about your file i have ever told you i can't download it just open amazon website if is possible upload to another website and unfortunately macro enable doesn't work

 

[Yongle]

Forgive me for intervening here but it would be better @abdelfattah you put the code in a NEW workbook to test it
and then tell @Logit what else the code must do

 

[abdelfattah]

hi, Yongle thanks for your advise actually , i did it nothing happened i 'm afraid i missed doing something but i no know what it is

 

[Yongle]

@Logit - over to you

 

[Logit]

Moving Around The VBE :

Enable Macros : Enable or disable macros in Office files

Create / Paste Macros : Create a Macro in Excel

Using The VBE : Visual Basic Editor Tutorial for Excel - How to use the VBE? - Analyst Cave



All of the above is all you need to learn how to code in VBA. If you understand the above ... you can create your own macros or use someone else's macros for your project.
Time for you to learn how to code.

 

[abdelfattah]

thanks logit but all of links above don't help to solve my problem theses steps i know i think reinstall the office

 

[Michael M]

@abdelfattah
Have you considered uploading your workbook to a hosting site, Dropbox for instance, then posting the link to that file back here
AND
a clear and concise description of your problem and what you expect as a solution.

 

[abdelfattah]

hi, logit actually i note the menu only show when i press right click into any cell but when i right click in header row or column or tab sheet not show the menu after run many macros and show in the bar menu two macros show bar and hide bar

 

[abdelfattah]

hi, Micheal i face a problem to restore bar menu right click to show again after hided
aaa.xlsm