Thread: excel 2007
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default excel 2007

On Sat, 27 Jun 2009 08:11:01 -0700, brbakrider
wrote:



"Dave Peterson" wrote:

Try rightclicking on the sheet tab. You should see a popup menu that includes
an option for renaming.

Yes Dave I have. That works on another workbook. I don't know why the
option is unavailable in this workbook, when I right click on the sheet name
tabs.


Might have saved some time if you had communicated this initially.

When you say the "option is unavailable" do you mean it is not there? or that
it is grayed out.

If it is grayed out, protection is one thing that can cause that. Go to the
Review ribbon and see if the workbook is protected. If it is, the option will
read Unprotect workbook. If it is not, it will read Protect workbook.
--ron