Unable to Insert Worksheet/Move and copy worksheet Excel 2003

  • Thread starter Thread starter lukerush
  • Start date Start date
L

lukerush

I've unprotected the file and am unable to Insert or move worksheets.
The options are greyed out. Any ideas?
 
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.
 
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.
 
If you have protected the workbook under Tools>Protection>Protect 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
 
If you have protected the workbook under Tools>Protection>Protect 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Move or Copy Stopped Working? 0
Excel 2007 Move or Copy worksheet 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Insert comment in protected worksheet 2
Copying cells in a protected worksheet 2
How do i disable/enable "Worksheet Move or copy" option? 1
Excel 07 worksheet problem - HELP!! 1

Back
Top