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.