It's the "options" button below the ribbon that appears when you open a
document. It disables any macros in a document until you enable it.

"Gord Dibben" wrote:

Enabled which "options button"?

Still sounds like workbook protection but you say you saw her remove it so
I'm out of ideas.


Gord


On Fri, 9 Apr 2010 09:15:01 -0700, Renee
wrote:

When she right clicks the tab for the worksheet the function to rename a
worksheet is grayed out.

The workbook was not protected as I watched her take the protection off.
And I watched her as she tried to rename the worksheet after removing the
protection. I also want to mention, which I didn't before, that she enabled
the options button after opening the workbook.

"Gord Dibben" wrote:

When you attempt to re-name a worksheet what happens?

Error message or??

Is the workbook protected under ReviewProtect Workbook?


Gord Dibben MS Excel MVP

On Fri, 9 Apr 2010 07:54:01 -0700, Renee
wrote:

We have an Excel 97/2003 workbook that we pulled up in Excel 2007; but we
noticed that with all the protections turned off there were some things that
we could not do, for example, renaming a worksheet. Anyone have any ideas
why that might happen? What can I do to fix it?

.


.