Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a sheet creates a new one
Excel (2003) file has multiple worksheets, (lots of them) and the user is
trying to delete some of them but Excel creates more sheets in their place. For example, user deletes sheet name abcsheet1 and it deletes but is replaced by abcsheet2, deletes abcsheet2, replaced by abcsheet3. Another part of the problem - is there a way to purge list of sheets after sheets are deleted? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a sheet creates a new one
sounds like there is a macro operating
check in the workbook module. "laralea" wrote: Excel (2003) file has multiple worksheets, (lots of them) and the user is trying to delete some of them but Excel creates more sheets in their place. For example, user deletes sheet name abcsheet1 and it deletes but is replaced by abcsheet2, deletes abcsheet2, replaced by abcsheet3. Another part of the problem - is there a way to purge list of sheets after sheets are deleted? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a sheet creates a new one
That wasn't it. Any other ideas?
"bj" wrote: sounds like there is a macro operating check in the workbook module. "laralea" wrote: Excel (2003) file has multiple worksheets, (lots of them) and the user is trying to delete some of them but Excel creates more sheets in their place. For example, user deletes sheet name abcsheet1 and it deletes but is replaced by abcsheet2, deletes abcsheet2, replaced by abcsheet3. Another part of the problem - is there a way to purge list of sheets after sheets are deleted? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a sheet creates a new one
this still sounds like a macro
set <tools<options<security <macro security in <security level set to very high in <trusted publishers unselect the trust all installed add-ins and templates hit OK until you are back at the worksheet close excel and reopen the workbook. try to delete a sheet if the problem still happens I have no idea what is going on. if it doesn't happen, there is a macro somewhere "laralea" wrote: That wasn't it. Any other ideas? "bj" wrote: sounds like there is a macro operating check in the workbook module. "laralea" wrote: Excel (2003) file has multiple worksheets, (lots of them) and the user is trying to delete some of them but Excel creates more sheets in their place. For example, user deletes sheet name abcsheet1 and it deletes but is replaced by abcsheet2, deletes abcsheet2, replaced by abcsheet3. Another part of the problem - is there a way to purge list of sheets after sheets are deleted? Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a sheet creates a new one
Might be easier to start in safe mode.
Close excel windows start button|run excel /safe click ok (macros will be disabled) File|Open your workbook and delete a sheet. What occurs? Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 10:33:01 -0700, bj wrote: this still sounds like a macro set <tools<options<security <macro security in <security level set to very high in <trusted publishers unselect the trust all installed add-ins and templates hit OK until you are back at the worksheet close excel and reopen the workbook. try to delete a sheet if the problem still happens I have no idea what is going on. if it doesn't happen, there is a macro somewhere "laralea" wrote: That wasn't it. Any other ideas? "bj" wrote: sounds like there is a macro operating check in the workbook module. "laralea" wrote: Excel (2003) file has multiple worksheets, (lots of them) and the user is trying to delete some of them but Excel creates more sheets in their place. For example, user deletes sheet name abcsheet1 and it deletes but is replaced by abcsheet2, deletes abcsheet2, replaced by abcsheet3. Another part of the problem - is there a way to purge list of sheets after sheets are deleted? Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a sheet creates a new one
I thought some macros could still run in safe mode?
"Gord Dibben" wrote: Might be easier to start in safe mode. Close excel windows start button|run excel /safe click ok (macros will be disabled) File|Open your workbook and delete a sheet. What occurs? Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 10:33:01 -0700, bj wrote: this still sounds like a macro set <tools<options<security <macro security in <security level set to very high in <trusted publishers unselect the trust all installed add-ins and templates hit OK until you are back at the worksheet close excel and reopen the workbook. try to delete a sheet if the problem still happens I have no idea what is going on. if it doesn't happen, there is a macro somewhere "laralea" wrote: That wasn't it. Any other ideas? "bj" wrote: sounds like there is a macro operating check in the workbook module. "laralea" wrote: Excel (2003) file has multiple worksheets, (lots of them) and the user is trying to delete some of them but Excel creates more sheets in their place. For example, user deletes sheet name abcsheet1 and it deletes but is replaced by abcsheet2, deletes abcsheet2, replaced by abcsheet3. Another part of the problem - is there a way to purge list of sheets after sheets are deleted? Thanks |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting a sheet creates a new one
I was attempting to disable any add-ins or hidden workbooks like Personal.xls in
xlstart or alternate startup location that may be doing the deed. Once OP opens the bad workbook, macros in that workbook will work, you are correct. So.......if OP has missed some code in a sheet or thisworkbook it will keep adding sheets in that workbook. Gord On Tue, 12 Jun 2007 14:37:02 -0700, bj wrote: I thought some macros could still run in safe mode? "Gord Dibben" wrote: Might be easier to start in safe mode. Close excel windows start button|run excel /safe click ok (macros will be disabled) File|Open your workbook and delete a sheet. What occurs? Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 10:33:01 -0700, bj wrote: this still sounds like a macro set <tools<options<security <macro security in <security level set to very high in <trusted publishers unselect the trust all installed add-ins and templates hit OK until you are back at the worksheet close excel and reopen the workbook. try to delete a sheet if the problem still happens I have no idea what is going on. if it doesn't happen, there is a macro somewhere "laralea" wrote: That wasn't it. Any other ideas? "bj" wrote: sounds like there is a macro operating check in the workbook module. "laralea" wrote: Excel (2003) file has multiple worksheets, (lots of them) and the user is trying to delete some of them but Excel creates more sheets in their place. For example, user deletes sheet name abcsheet1 and it deletes but is replaced by abcsheet2, deletes abcsheet2, replaced by abcsheet3. Another part of the problem - is there a way to purge list of sheets after sheets are deleted? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clairification in finding and deleting cells from one sheet to ano | Excel Discussion (Misc queries) | |||
finding and deleting cells from one excel sheet to another | Excel Discussion (Misc queries) | |||
Clicking cells on sheet creates Text Box. How do I turn this off? | Excel Discussion (Misc queries) | |||
how to protect sheet from adding/deleting | Excel Discussion (Misc queries) | |||
Deleting every-other row in a spread sheet | Excel Discussion (Misc queries) |