Sheet delete is disabled, how to enable?

  • Thread starter Thread starter ViestaWu
  • Start date Start date
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
 
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.
 
Back
Top