|
Locked
I cannot delete or rename a worksheet. Pls advise...
|
Locked
I suspect it's protected, possibly with password. Try
ToolsProtectionUnprotect sheet... -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "MK" wrote in message ... I cannot delete or rename a worksheet. Pls advise... |
Locked
Thanks. The worksheet is not protected
"Nick Hodge" wrote: I suspect it's protected, possibly with password. Try ToolsProtectionUnprotect sheet... -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "MK" wrote in message ... I cannot delete or rename a worksheet. Pls advise... |
Locked
Do you get any error when you attempt it? If not, how are you attempting it?
-- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "MK" wrote in message ... Thanks. The worksheet is not protected "Nick Hodge" wrote: I suspect it's protected, possibly with password. Try ToolsProtectionUnprotect sheet... -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "MK" wrote in message ... I cannot delete or rename a worksheet. Pls advise... |
Locked
It sounds like the workbook is protected--not the worksheet.
Tools|Protection|unprotect workbook (You may need to supply the password) MK wrote: I cannot delete or rename a worksheet. Pls advise... -- Dave Peterson |
Locked
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" wrote: Do you get any error when you attempt it? If not, how are you attempting it? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "MK" wrote in message ... Thanks. The worksheet is not protected "Nick Hodge" wrote: I suspect it's protected, possibly with password. Try ToolsProtectionUnprotect sheet... -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "MK" wrote in message ... I cannot delete or rename a worksheet. Pls advise... |
Locked
Yep...protected workbook
-- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "MK" wrote in message ... 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" wrote: Do you get any error when you attempt it? If not, how are you attempting it? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "MK" wrote in message ... Thanks. The worksheet is not protected "Nick Hodge" wrote: I suspect it's protected, possibly with password. Try ToolsProtectionUnprotect sheet... -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "MK" wrote in message ... I cannot delete or rename a worksheet. Pls advise... |
Locked
Done ...Thanks
"Dave Peterson" wrote: It sounds like the workbook is protected--not the worksheet. Tools|Protection|unprotect workbook (You may need to supply the password) MK wrote: I cannot delete or rename a worksheet. Pls advise... -- Dave Peterson |
| All times are GMT +1. The time now is 10:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com