Move or Copy Sheet is Disabled

  • Thread starter Thread starter blaked
  • Start date Start date
B

blaked

In the Edit menu the Delete Sheet and Move or Copy Sheet functions ar
not enabled. Also, when I try to right click the worksheet tab,
don't get any response, even though the right click works inside th
sheet itself. Would someone please tell me how to get this workin
again? I need your help. Thanks
 
Right Click on edit then goto customize clcik the commands tab the
clcik edit you should then be able to add delete sheet to edit again

Also the sheet may be protected and hence the reason you can not delet
it.

does it ask you to enable macros when you open the workbook? if so a
autoopen macro maybe running which may contain code to disable thi
featur
 
Is your workbook protected?

Tools|protection
If it's protected, you'll see an option to "unprotect workbook".

You may be prompted for a password if it's protected.

And my "edit|delete sheet" is disabled if the workbook is shared?

(The move or copy is still enabled, though.)
 
Have you customised your standard menu bar?

If you haven't then right-click on it, choose customise,
click on the standard menu bar in the drop down list and
then press Reset.

If this doesn't work then try the following:
Press Alt-F11 - this will take you to the Visual Basic screen
Press Ctl-G - this will open up the immediate pane
Type the following 2 lines into the immediate pane (press enter
after each line):
Application.CommandBars("Ply").Reset
Application.CommandBars("Ply").Visible=True

Hope this helps

Regards
Alan
 
Back
Top