ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel "Move or Copy" and "Delete" sheet functions (https://www.excelbanter.com/excel-worksheet-functions/170815-excel-move-copy-delete-sheet-functions.html)

dsiama

Excel "Move or Copy" and "Delete" sheet functions
 
Hello to all,
Since a couple of weeks now the options of the "move or Copy" and "delete"
in the Excell sheets has been lost in my PC. This is even with right click on
the sheet tab or in the Edit menu. Even in new sheets that I create! I can
see them in the menus but they are "grey" (you can not click on them).

Can anybody help? Do you know how can take these back again?
Thanks a lot
Dsiama

ryguy7272

Excel "Move or Copy" and "Delete" sheet functions
 
Maybe you can try a small macro such as the one below:
Sub Tlbars()
Application.CommandBars.Item("Edit").Enabled = True ' enables the dropdown
End Sub

Regards,
Ryan--

--
RyGuy


"dsiama" wrote:

Hello to all,
Since a couple of weeks now the options of the "move or Copy" and "delete"
in the Excell sheets has been lost in my PC. This is even with right click on
the sheet tab or in the Edit menu. Even in new sheets that I create! I can
see them in the menus but they are "grey" (you can not click on them).

Can anybody help? Do you know how can take these back again?
Thanks a lot
Dsiama



All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com