Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Delete Sheets or see Properties
OK so this is weird. I am unable to delete a worksheet. The workbook
is not protected nor is it shared, and there is no VBA code. In fact if I just open Excel and get the default 3 sheet blank workbook, I have the same problem. Delete sheets is grayed out. Also I cannot see the Properties under the file menu. It is grayed out too. This just suddenly happened today, with any spreadsheet. What I can do is "Move or copy sheet" and move a sheet to another workbook, then delete that workbook. Anyone have any clues, or even ideas how to debug this? Thanks -- Rev |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Delete Sheets or see Properties
I found the problem. Last Friday I had opened someone elses Excel
workbook that had this code in it. The code apparently disables some menu options, and those remain disabled even if Excel is closed and restarted. I was able to re-enable the menu items by inverting the logic and running the macro. Wow how annoying. 'Option Explicit 'Private Sub workbook_activate() 'Dim Con As CommandBarControl, conb As CommandBarControl ' For Each Con In Application.CommandBars.FindControls(ID:=847) ' Con.Enabled = False ' Next ' For Each conb In Application.CommandBars.FindControls(ID:=750) ' conb.Enabled = False ' Next 'End Sub On Oct 12, 12:43*pm, Revolvr wrote: OK so this is weird. I am unable to delete a worksheet. The workbook is not protected nor is it shared, and there is no VBA code. In fact if I just open Excel and get the default 3 sheet blank workbook, I have the same problem. Delete sheets is grayed out. Also I cannot see the Properties under the file menu. It is grayed out too. This just suddenly happened today, with any spreadsheet. What I can do is "Move or copy sheet" and move a sheet to another workbook, then delete that workbook. Anyone have any clues, or even ideas how to debug this? Thanks -- Rev |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Delete Sheets or see Properties
You may want to let them know to add something to their code to turn things
back on. I've had common shortcuts really messed up (things like CTRL A, or CTRL P) with programmed keys for macros. Barb Reinhardt "Revolvr" wrote: I found the problem. Last Friday I had opened someone elses Excel workbook that had this code in it. The code apparently disables some menu options, and those remain disabled even if Excel is closed and restarted. I was able to re-enable the menu items by inverting the logic and running the macro. Wow how annoying. 'Option Explicit 'Private Sub workbook_activate() 'Dim Con As CommandBarControl, conb As CommandBarControl ' For Each Con In Application.CommandBars.FindControls(ID:=847) ' Con.Enabled = False ' Next ' For Each conb In Application.CommandBars.FindControls(ID:=750) ' conb.Enabled = False ' Next 'End Sub On Oct 12, 12:43 pm, Revolvr wrote: OK so this is weird. I am unable to delete a worksheet. The workbook is not protected nor is it shared, and there is no VBA code. In fact if I just open Excel and get the default 3 sheet blank workbook, I have the same problem. Delete sheets is grayed out. Also I cannot see the Properties under the file menu. It is grayed out too. This just suddenly happened today, with any spreadsheet. What I can do is "Move or copy sheet" and move a sheet to another workbook, then delete that workbook. Anyone have any clues, or even ideas how to debug this? Thanks -- Rev |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Delete Sheets or see Properties
On Oct 12, 1:54*pm, Barb Reinhardt
wrote: You may want to let them know to add something to their code to turn things back on. * I've had common shortcuts really messed up (things like CTRL A, or CTRL P) with programmed keys for macros. * Barb Reinhardt Turns out they did, when the spreadsheet closed normally, it had enable logic. Problem is if the workbook doesn't close normally. In my case it crashed. I think as a design practice there must be a better way to handle it that would not have a possibility of leaving Excel changed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UNABLE TO DELETE FOLDER | Excel Discussion (Misc queries) | |||
Unable to delete documents | New Users to Excel | |||
How do I delete or edit this- file properties statistics in excel. | Excel Discussion (Misc queries) | |||
Unable to see Properties in Design View for controls | Excel Worksheet Functions | |||
Unable to set Properties in Excel | Excel Programming |