I have a large workbook I use to record purchase orders in, for what its
worth the workbook was started on a Windows 95 Office 97 computer, as the
years have gone by different computers,users have been adding info and making
changes.
There are 4 sheets. I am trying to divide this year into quarters by making
another sheet.
When I try to do this, the "copy sheet" or "move sheet" info is shown in
gray, rather than bold type so I am unable to use these drop downs and click
on what I am trying to do. From what I can tell , the workbook is not
password protected, I am baffled a bit.
I don't have a network, I work in the day on a desktop, then copy this file
to a "memory stick" and some nights take home to work on my laptop. I then
resave the whole notebook. I am trying to get where I just can use the
current year instead of every time I save or add to it, I copy all 4 sheets.

Ideally, I would like to just have one sheet per year, and be able to break
that down to semi-annual or quarters, just so when I take the work home I
don't have to copy the whole database just to work with a few rows.
--
Rick M

"From what I can tell" leads me to believe there might be some uncertainty.

Have you looked under ToolsProtection to see if Unprotect Workbook is
available?


Gord Dibben MS Excel MVP

On Fri, 13 Oct 2006 09:10:01 -0700, Rick M
wrote:

I have a large workbook I use to record purchase orders in, for what its
worth the workbook was started on a Windows 95 Office 97 computer, as the
years have gone by different computers,users have been adding info and making
changes.
There are 4 sheets. I am trying to divide this year into quarters by making
another sheet.
When I try to do this, the "copy sheet" or "move sheet" info is shown in
gray, rather than bold type so I am unable to use these drop downs and click
on what I am trying to do. From what I can tell , the workbook is not
password protected, I am baffled a bit.
I don't have a network, I work in the day on a desktop, then copy this file
to a "memory stick" and some nights take home to work on my laptop. I then
resave the whole notebook. I am trying to get where I just can use the
current year instead of every time I save or add to it, I copy all 4 sheets.

Ideally, I would like to just have one sheet per year, and be able to break
that down to semi-annual or quarters, just so when I take the work home I
don't have to copy the whole database just to work with a few rows.