Cannot Move, Copy, Insert, Rename, or Delete a Worksheet in Any Wo

J

JG

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.
 
D

Dave Peterson

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.
 
J

JG

This leads me to another question. If I have blocked out all of those
features using VBA, then this command overrides all of my VBA protection. Is
there a way to block people from using this command?
 
D

Dave Peterson

You can try your best to block them from getting to the VBE, but I gotta believe
that anyone really interested will find a way around it.

Heck, they may have macros in other workbooks that do this kind of thing. Then
they can just open that other workbook and run those macros.

But if you want to try, you could look at this book:

http://www.amazon.com/dp/0321262506
Professional Excel Development: The Definitive Guide to Developing Applications
Using Microsoft Excel and VBA
By Stephen Bullen, John Green, Rob Bovey

If I recall correctly, it describes how to make a dictator application within
excel that controls the environment exactly how you want.
 
J

JG

Dave,

May I enlist your help once more? I ran into another problem. Now the
"save as" is grayed out (meaning it's there, but i can't use it). Your
previous fix isn't working.
Any suggestions?

Thanks!
 
D

Dave Peterson

Maybe you can reset that toolbar manually:

Tools|customize|toolbars tab
select worksheet menu bar
and click reset

But this should do the same thing as that line of code.
Dave,

May I enlist your help once more? I ran into another problem. Now the
"save as" is grayed out (meaning it's there, but i can't use it). Your
previous fix isn't working.
Any suggestions?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top