| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locked
I cannot delete or rename a worksheet. Pls advise...
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My num pad is locked | Excel Discussion (Misc queries) | |||
| Locked somehow | Excel Worksheet Functions | |||
| LOCKED | Excel Discussion (Misc queries) | |||
| Locked Formatting | Excel Discussion (Misc queries) | |||
| Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
Linear Mode
