View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Cannot Move, Copy, Insert, Rename, or Delete a Worksheet in Any Wo

Does this mean that the options are gone and you can't choose them or that the
options are there, but they don't work.

If the options are missing, you could reset the toolbars:

Open excel.
start a new workbook
open the VBE (hit alt-f11)
hit ctrl-g
type this:
application.CommandBars("worksheet menu bar").Reset
And hit enter

Then type this:
application.CommandBars("ply").Reset
and hit enter.

The first resets all the options in the File|edit|view menu bar.

The second resets all the options on the worksheet tab menu.

If the options are still there, but don't work, try this technique, too. If
that doesn't help, write back describing what you do and what excel does.

JG wrote:

In Excel 2000, whether I create a new workbook or open an existing one, I can
no longer Move, Copy, Insert, Rename, or Delete a Worksheet in Any Workbook
either by right-clicking on the sheet tab or using the edit menu.

Protect Worksheet is Off. Protect Workbook is Off.

Things to Note:
1. I had been testing another workbook which had those features disabled by
using VBA code. However, using that workbook on other computers has not had
the same effect.

2. I had also tried a demo on Done-EX the Excel Compiler.

3. Both items 1 & 2 have now been removed from my computer but the problem
persists.

4. I have tried repairing and reinstalling Excel but this hasn't helped.


--

Dave Peterson