how do I change the order of worksheets in a workbook

D

DanielLipkie

In Excel 2007, how do I change the order of worksheets in a workbook? In
Excel 2003 I could move the worksheet tabs at the bottom of the workbook
 
E

Elkar

It should be the same as 2003. Either click and drag the worksheet tab to
the desired position, or right-click and select "Move or Copy".

Is the Workbook protected? If so, try unprotecting it (under the Review
Tab) and see if you can move them then.

HTH,
Elkar
 
D

DanielLipkie

Thanks ... it is protected BUT I entered the correct password to "unprotect"
it when I opened it. The Review |Protected tab has the following checked
- Protect Structure & Windows
- Unrestricted Access

I would have thought this is sufficient to change the worksheet order.

But I did as you suggested ... removed the protection. Then I could
re-order. Then I put protection back on.

Thanks.
 

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

How do I change the order of worksheets in a workbook 1
How to display the merge function "url" of a picture? 0
How do I remove the top half of a block interval? 1
Set the print order of worksheets when printing entire workbook 2
How do I link a cell in a workbook? 1
VBA to do a mailmerge from a Specific Excel worksheet 0
Merging from an Excel file with graphics 1
Start sheet in a workbook 2

Top