Deleting a sheet creates a new one

G

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
 
G

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
 
G

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top