Deleting a sheet creates a new one

[Guest]

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

 

[Guest]

sounds like there is a macro operating
check in the workbook module.

 

[Guest]

That wasn't it. Any other ideas?

sounds like there is a macro operating
check in the workbook module.

 

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

I thought some macros could still run in safe mode?

 

[Gord Dibben]

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