Can't Insert of remove worksheet in an existing workbook

B

beginer1

Need your help from you experts.
Please give me suggestion how to fix the problem with my excel file.
I'm not able to add or remove worksheet from my existing excel
workbook. When I right click on the tabs, it gives only two options:
"Select All Sheets" and "View Code", other choices are grayed out. The
file has about 17 tabs, but I could remove or add worksheet to it
before. I did save it with a password to open it and running the macro
RowLine.xla, but I now can't add or remove sheet, so I remove the
password and the macro, and I still can't add or remove sheet.
Is there a way to check if there're still macros in the file, and want
to remove them all. Thank you much
 
G

Govind

Hi,

Did you check if the workbook is protected? If yes, then unprotect it
first and then try this.

regards

Govind.
 
B

beginer1

hello Govind,
when I saved the file , I clicked on File/SAve as/ Tools/ General
Options / I entered the password to open/ save , [I didn't set password
to modify, then I undid this by going to the tools menu / options/
Security tab / removed the password. I now open the file without being
asked to enter the password as before. it indicates the whole workbook
is not protected by a password. Any other suggestion. Thanks
 
G

Govind

Hi,

Am not referring to the file password. Am referring to
Tools->Protection->Protect/(Unprotect) workbook.When the workbook is
protected, you wont be able to delete sheets.

Regards

Govind.
 
Top