Locked

[MK]

I cannot delete or rename a worksheet. Pls advise...

 

[Nick Hodge]

I suspect it's protected, possibly with password. Try
Tools>Protection>Unprotect sheet...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[MK]

Thanks. The worksheet is not protected

I suspect it's protected, possibly with password. Try
Tools>Protection>Unprotect sheet...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[Nick Hodge]

Do you get any error when you attempt it? If not, how are you attempting it?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[Dave Peterson]

It sounds like the workbook is protected--not the worksheet.

Tools|Protection|unprotect workbook
(You may need to supply the password)

 

[MK]

When I right click on 3 accessible column, View Code, Protect sheet and
Select All Sheets, The rest like Insert, Rename, Tab...... are not
accessible. I can change the content of the worksheet but also unable to add
new worksheet.

 

[Nick Hodge]

Yep...protected workbook

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[MK]

Done ...Thanks

It sounds like the workbook is protected--not the worksheet.

Tools|Protection|unprotect workbook
(You may need to supply the password)