Menus options are grayed out in Excel 2003

K

Kimi

I'm having trouble with several of my menu options being grayed out in Excel
2003. When I have a blank workbook option, several options are not available
to me: options, security, protection, macros, formula auditing, inserting
rows, columns, pictures, etc. However, if I sign into my husband's user
account, those options are all available to me. My profile is assigned as an
administrator, so I should have full accesss. The odd thing is that this is
only doing this in Excel and no other office programs.

My company gives us Excel docs with macros to report our financials. My main
frustration is that I don't have the option to change my security levels to
enable macros under my profile using Excel. I have the option to enable
macros under my husband's profile when I sign into his.

Any ideas?
 
E

Excelenator

If the workbook is shared then some of the menu items will be grayed
out. You have to unshare the workbook and then you will have full
functionality.
 
K

Kimi

The workbook is not shared and I'm having this problem on every single file
that I open with Excel, not just one. If I just open a blank workbook, I
still do not have the ability to use about four menu options under each main
menu.

But I don't have this problem under my husband's profile.
 

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

Top