Ask Experts Questions for FREE Help !
Ask
    malerieh's Avatar
    malerieh Posts: 4, Reputation: 1
    New Member
    		  
    #1

    Jul 24, 2009, 07:05 AM
    Excel Protection Gray-Out
    I am currently working with Excel 2002. I've had this version for years and this problem only recently occurred. When I click on Tools the Protection option as well as the compare and merge Workbooks option is grayed-out, thus preventing me from protecting or unprotecting workbooks.

    Has anyone run across this before and if so how do I fix this?

    Thanks.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jul 24, 2009, 08:14 AM

    This happens when you open the program and start a new document? Or only when you open an existing doc?
    malerieh's Avatar
    malerieh Posts: 4, Reputation: 1
    New Member
    		  
    #3

    Jul 24, 2009, 08:17 AM
    It is grayed-out when I create a new spreadsheet or view an old one.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #4

    Jul 24, 2009, 12:30 PM

    Try this:
    1. Choose Customize from the Tools menu. You will see the Customize dialog box.
    2. Make sure the Toolbars tab is selected. (Click here to see a related figure.)
    3. In the list of available toolbars, select the one you want to reset.
    4. Click on the Reset button. You are asked to confirm resetting of the toolbar.
    5. Click on OK to reset the toolbar.
    6. Repeat steps 3 through 5 for each toolbar you want to reset.
    7. Click on Close to dismiss the Customize dialog box.


    (source)
    malerieh's Avatar
    malerieh Posts: 4, Reputation: 1
    New Member
    		  
    #5

    Jul 24, 2009, 12:48 PM

    It wasn't a toolbar that was the problem. However, I went to Commands then Tools and hit modify selection and it gave me the option to reset, which I did. Hopefully, I didn't cause a new problem because I now can have the ability to protect a worksheet.

    Thanks for you quick response and tremendous help.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Hair gone gray [ 1 Answers ]

About a year ago i used to have a blonde fringe and black hair, then i got rid of it and went to all black. i had it all one color for ages. about 4 months ago i went back to a blonde fringe and it was fine for ages, then i tryed to dye it red and the roots went red but the ends stayed blonde. ...

Excel 2007 to have excel 2003 look? [ 6 Answers ]

Hey I have Microsoft Excel 2007, from my course at college I have been given instructions to do a task. However these instructions are for excel 2003. How do I change my excel 07 to look like excel 03 so that it is easier. I know there is a way, help greatly appreicated thanks.

Gray hair too much [ 1 Answers ]

I am 57 years old. I have been completely gray for about five years. My hair was originally very dark brown (almost black) and long. I started getting gray in my 20's, so I spent years coloring my hair. I finally decided to let the gray grow out. Now, that it's completely gray, it seems to be...

MS Excel Protection options [ 5 Answers ]

I have a HUGE Excel File of 10 Worksheets with usernames and passwords. Until now I've just had the whole file password protected. Since only a couple columns in each worksheet are private, I'd like to "hide" the columns so that a password must be entered to see them. Is this possible? ...

View more questions Search