how do i rename a sheet if the rename tab is inactive?

N

Nelson

I tried to rename a sheet in a workbook but discovered that the rename option
is inactive when i right-clicked on the sheet. How do i make it active ?
 
M

Mike H

Hi,

This would happen if the 'workbook' was protected.

Tools|Protection|Unprotect workbook

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable to rename a tab in a worksheet via VBA 5
How do I insert the file name as my Worksheet name in the tab? 1
Rename Sheet from a cell value 3
What is the keyboard shortcut 2 bring up the excel sheet tab menu? 3
Formulas That Reference ADJACENT Sheet 4
The Sheet-Rename feature is greyed-out in my Excel 2003 workbook.. 1
Sheet Tabs 5
How do i add a new entry to an existing drop-down list in Excel? 2

Top