ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/235162-excel-2007-a.html)

brbakrider

excel 2007
 
I have been unable to rename workbook sheets. Please advise


Fred Smith[_4_]

excel 2007
 
What have you tried, and what error message did you get? What happens when
you rename in Explorer?

Regards,
Fred.

"brbakrider" wrote in message
...
I have been unable to rename workbook sheets. Please advise



brbakrider

excel 2007
 


"Fred Smith" wrote:

What have you tried, and what error message did you get? What happens when
you rename in Explorer?

Regards,
Fred.

"brbakrider" wrote in message
...
I have been unable to rename workbook sheets. Please advise


Do you have excel 2007? There does not seem to be an option to rename sheet tabs. I do not use explorer, why would it matter?


Dave Peterson

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

brbakrider wrote:

"Fred Smith" wrote:

What have you tried, and what error message did you get? What happens when
you rename in Explorer?

Regards,
Fred.

"brbakrider" wrote in message
...
I have been unable to rename workbook sheets. Please advise


Do you have excel 2007? There does not seem to be an option to rename sheet tabs. I do not use explorer, why would it matter?


--

Dave Peterson

brbakrider

excel 2007
 


"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.

Ron Rosenfeld

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


All times are GMT +1. The time now is 08:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com