Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 7th 06, 03:37 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 2
Default 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   Report Post  
Old September 7th 06, 04:43 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 2
Default 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   Report Post  
Old September 7th 06, 05:05 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy and paste between windows in excel 2003 will not work april g. Excel Worksheet Functions 0 March 2nd 06 07:35 PM
Excel 2003 - Copy Cell Reference Nicole Excel Worksheet Functions 2 September 7th 05 05:46 PM
exporting excel worksheet to word morrowkd Links and Linking in Excel 1 May 11th 05 11:23 PM
Can't Copy and Paste between Excel 2003 Workbooks wllee Excel Discussion (Misc queries) 6 March 30th 05 02:59 PM
LINEST bug with cubic polynomials in Excel 2003 byundt Excel Worksheet Functions 3 March 21st 05 02:15 PM


All times are GMT +1. The time now is 09:42 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017