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

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

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

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

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

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

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