Cannot move/copy Excel 97 worksheet

C

Catherine

Does anyone know why, when I right-click on a worksheet in an Excel 97
workbook, the More or Copy command on the pop-up window is grayed out? The
only commands available are Select All Sheets and View Code. The workbook on
which this file was based enables the user to move/copy worksheets, but this
one doesn't. Both are password protected.

What type of things could the user have done to this file that would make
this command be disabled? In other words, what should I look for to resolve
the problem?

Thanks!

Catherine
 
C

Catherine

Haven't tried that yet, since I don't have the password. However, I'll get
the password and see what the results are.
 
D

Dave Peterson

Did you protect the workbook?

Tools|protection|protect workbook (or unprotect workbook to remove it)
 
C

Catherine

Dave -- Thanks for giving me the hint! The user had inadvertently protected
both the worksheet AND the workbook. I'd undone the worksheet protection,
but didn't think to check protection on the workbook itself.

Thanks to both of you for your help!

Catherine
 
Top