I keep reading the Excel Help and rubbing my eyes and looking at Excel and
rubbing my eyes some more . . .

I need to prevent users from changing the names of my worksheets. I have a
few formulas that "hard code" sheet names inside INDIRECT formulas, so any
change to the sheet names causes a Ref# error. When I looked in Help it says
the following:

On the Tools menu, point to Protection, and then click Protect Workbook. To
protect the structure of a workbook so that worksheets in the workbook can't
be moved, deleted, hidden, unhidden, or renamed, and new worksheets can't be
inserted, select the Structure check box.

I see no such menu option in Excel 2003. There is something about Worksheet
Sharing, but not the basic protection features described in Help. There has
to be a way - besides some type of VBA workaround - to prevent users from
changing the names of worksheets, right?

I have excel 2003 and if I click on protect workbook the "structure" option
box displays. You could also try password protection on the sheet or
workbook.

"andy62" wrote:

I keep reading the Excel Help and rubbing my eyes and looking at Excel and
rubbing my eyes some more . . .

I need to prevent users from changing the names of my worksheets. I have a
few formulas that "hard code" sheet names inside INDIRECT formulas, so any
change to the sheet names causes a Ref# error. When I looked in Help it says
the following:

On the Tools menu, point to Protection, and then click Protect Workbook. To
protect the structure of a workbook so that worksheets in the workbook can't
be moved, deleted, hidden, unhidden, or renamed, and new worksheets can't be
inserted, select the Structure check box.

I see no such menu option in Excel 2003. There is something about Worksheet
Sharing, but not the basic protection features described in Help. There has
to be a way - besides some type of VBA workaround - to prevent users from
changing the names of worksheets, right?

ToolsProtectionProtect Workbook is a standard meny item and does what you
want.

Perhaps it has been dragged off the Tools menu?

Go to ToolsCustomize then right-click on Tools on your menu bar and "Reset"

Also while in ToolsCustomize dialog open the Options tab and "always show full
menus"

A note of warning here. You can password protect a workbook under
ToolsProtection but Excel's internal security is quite weak and passwords can
easily be broken.


Gord Dibben MS Excel MVP


On Sun, 8 Jul 2007 18:48:02 -0700, andy62
wrote:

I keep reading the Excel Help and rubbing my eyes and looking at Excel and
rubbing my eyes some more . . .

I need to prevent users from changing the names of my worksheets. I have a
few formulas that "hard code" sheet names inside INDIRECT formulas, so any
change to the sheet names causes a Ref# error. When I looked in Help it says
the following:

On the Tools menu, point to Protection, and then click Protect Workbook. To
protect the structure of a workbook so that worksheets in the workbook can't
be moved, deleted, hidden, unhidden, or renamed, and new worksheets can't be
inserted, select the Structure check box.

I see no such menu option in Excel 2003. There is something about Worksheet
Sharing, but not the basic protection features described in Help. There has
to be a way - besides some type of VBA workaround - to prevent users from
changing the names of worksheets, right?

Thanks, Gord, but for some reason even Reset does not restore the missing
menu item. But you got me to a workaround: from the long list of toolbars I
selected "Protection" which popped up with five little icons, one of which is
"Protect Workbook" and provides the missing functionality. Funny, though,
that I cannot restore it onto the regular drop-down menu. Some errant gamma
ray hit just the right spot on my hard drive, maybe. Thanks.

"Gord Dibben" wrote:

ToolsProtectionProtect Workbook is a standard meny item and does what you
want.

Perhaps it has been dragged off the Tools menu?

Go to ToolsCustomize then right-click on Tools on your menu bar and "Reset"

Also while in ToolsCustomize dialog open the Options tab and "always show full
menus"

A note of warning here. You can password protect a workbook under
ToolsProtection but Excel's internal security is quite weak and passwords can
easily be broken.


Gord Dibben MS Excel MVP


On Sun, 8 Jul 2007 18:48:02 -0700, andy62
wrote:

I keep reading the Excel Help and rubbing my eyes and looking at Excel and
rubbing my eyes some more . . .

I need to prevent users from changing the names of my worksheets. I have a
few formulas that "hard code" sheet names inside INDIRECT formulas, so any
change to the sheet names causes a Ref# error. When I looked in Help it says
the following:

On the Tools menu, point to Protection, and then click Protect Workbook. To
protect the structure of a workbook so that worksheets in the workbook can't
be moved, deleted, hidden, unhidden, or renamed, and new worksheets can't be
inserted, select the Structure check box.

I see no such menu option in Excel 2003. There is something about Worksheet
Sharing, but not the basic protection features described in Help. There has
to be a way - besides some type of VBA workaround - to prevent users from
changing the names of worksheets, right?

Thanks for the feedback.

Gord

On Sun, 8 Jul 2007 20:34:00 -0700, andy62
wrote:

Thanks, Gord, but for some reason even Reset does not restore the missing
menu item. But you got me to a workaround: from the long list of toolbars I
selected "Protection" which popped up with five little icons, one of which is
"Protect Workbook" and provides the missing functionality. Funny, though,
that I cannot restore it onto the regular drop-down menu. Some errant gamma
ray hit just the right spot on my hard drive, maybe. Thanks.

"Gord Dibben" wrote:

ToolsProtectionProtect Workbook is a standard meny item and does what you
want.

Perhaps it has been dragged off the Tools menu?

Go to ToolsCustomize then right-click on Tools on your menu bar and "Reset"

Also while in ToolsCustomize dialog open the Options tab and "always show full
menus"

A note of warning here. You can password protect a workbook under
ToolsProtection but Excel's internal security is quite weak and passwords can
easily be broken.


Gord Dibben MS Excel MVP


On Sun, 8 Jul 2007 18:48:02 -0700, andy62
wrote:

I keep reading the Excel Help and rubbing my eyes and looking at Excel and
rubbing my eyes some more . . .

I need to prevent users from changing the names of my worksheets. I have a
few formulas that "hard code" sheet names inside INDIRECT formulas, so any
change to the sheet names causes a Ref# error. When I looked in Help it says
the following:

On the Tools menu, point to Protection, and then click Protect Workbook. To
protect the structure of a workbook so that worksheets in the workbook can't
be moved, deleted, hidden, unhidden, or renamed, and new worksheets can't be
inserted, select the Structure check box.

I see no such menu option in Excel 2003. There is something about Worksheet
Sharing, but not the basic protection features described in Help. There has
to be a way - besides some type of VBA workaround - to prevent users from
changing the names of worksheets, right?