Disabled "Delete" for one workbook turned out to be applied to every workbook...

Good morning everyone ,

I had coffee yesterday evening and could not sleep early so I worked on some spreadsheets...

I wanted to disable the function "Delete" when right-clicking on worksheets.

I copy paste the following VBA code in every sheet code :

Please Login or Register  to view this content.

It worked fine. Then I opened another project workbook to work on it and guess what, the function delete was also disabled !

So I went back to the previous workbook and deleted from every sheet code the previous code. But it did not work and for every Excel workbook I opened, when I right-clicked on a sheet, the function "delete" is disabled...

so here I am, panicking, I really don't know what to do. So I am here this morning and last night sleep didn't help me to solve this problem.

Does anyone have a clue to help me ? Do you think an uninstall and new install might solve this problem ??

I am really helpless

Susie

You adjusted an Application.CommandBars item, hence it is adjusted at APPLICATION level.

To reinstate it you just need to change your 'FALSE' to 'TRUE'.

You can either alter it in your original workbook, or else open a new workbook, and insert this code into a new module, then run it:

Please Login or Register  to view this content.

Incidentally, in the workbook you were trying to disable the 'Delete' for, place the following code into the 'ThisWorkBook' section of the VB Editor:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

That will then disable the delete command whenever that workbook is active, and re-enable the delete command whenever that workbook is not active

FWIW, you could simplify a bit:

Please Login or Register  to view this content.

You are both awesome
I really thought I was in trouble

Is there any way to also disable the "rename" function ?

I tried the following code in each sheet :

Please Login or Register  to view this content.

It allowed renaming sheet but when going to another sheet, excel renamed it back to the original name. However, this method messes up with the hyperlink I have implemented in the sheet.

It would be better to have it disable like the "delete" function.

Thanks

Susie

Susie,

Please edit your post to add code tags.

Hi Susie,

This will disable the 'Rename' command on the tab right-click menu:

Please Login or Register  to view this content.

Change back to TRUE and run the code to re-enable the command.

it is done, I spent 15min wondering how to do it

The forum rules are a fount of useful information, including that. I commend them to your reading

Please take a few minutes to read the forum rules, start your own thread, and use code tags around code.