| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003
I've unprotected the file and am unable to Insert or move worksheets.
The options are greyed out. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unable to Insert Worksheet/Move and copy worksheet Excel 2003
Disregard this. I figured it out. For whatever reason if you put a
password in that is wrong on the Unprotect Workbook option, it does not re-prompt you or tell you if the password is bad. I obtained the correct password and was able to unprotect the workbook. Now all functions work. lukerush wrote: I've unprotected the file and am unable to Insert or move worksheets. The options are greyed out. Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unable to Insert Worksheet/Move and copy worksheet Excel 2003
If you have protected the workbook under ToolsProtectionProtect Workbook and
checked "Structure" the features you describe will be unavailable. Ideas?.............Protect the workbook with only "Windows" checked or do not protect at all. What prompted you to protect the workbook in the first place? Gord Dibben MS Excel MVP On 7 Sep 2006 07:37:54 -0700, "lukerush" wrote: I've unprotected the file and am unable to Insert or move worksheets. The options are greyed out. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste between windows in excel 2003 will not work | Excel Worksheet Functions | |||
| Excel 2003 - Copy Cell Reference | Excel Worksheet Functions | |||
| exporting excel worksheet to word | Links and Linking in Excel | |||
| Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) | |||
| LINEST bug with cubic polynomials in Excel 2003 | Excel Worksheet Functions | |||
Linear Mode
