Sheet delete is disabled, how to enable?

V

ViestaWu

Dear Friends,

I have a excel which seems now allowed me to delete any sheets.
Those methods I tried to delete the sheet are as follows:
1. right click on the sheet tab, only "select all sheets" and "view codes"
are enabled, others are in grey.
2. Menu bar, edit, delete sheet is in grey.
3. Properties changes from sheets visible to sheets hidden is not allow,
with an error message is " unable to set the visible property of the
worksheet class".
4. macro is tried to delete it worksheets(2).delete, but error.

I feel that some property has been setup to lock the changes to worksheets,
but I have no idea to find the settings. I beg that anyone could show me the
answers.

Thanks at advance! Happy new year!
Viesta
 
S

ShaneDevenshire

Hi,


Maybe the workbook's structure is protected - choose Tools, Protection, and
see if the sub menu has Protect Workbook or Unprotect Workbook. If the
second one is displayed it means the Workbook is protected here and you
should unprotect it.
 

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

Similar Threads

Can't delete sheets 8
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
hide multiple worksheets based on a formula value in one cell 1
Delete line in sheet, deletes same line in add'l sheets 1
Excel Hw to delete a row from an excel sheet after copying its contents to another sheet 1
Button for every sheet one new email 0
How to hide password? 1
Excel Code to run ActiveWindow.View in normal view, only runs manually. 21

Top