grey out insert menu options

[gemini3rdeye]

Good day,

When opening up a new excel spread sheet and selecting the insert menu the
columns, rows and cells are grey and unavailable. I am using windows xp with
SP/2 and MS office 2003. I tried to run a repair and reinstall excel and this
did not fix the problem. Any help would be great! Thank you for your time.

 

[JNW]

Is the sheet or workbook protected?

 

[gemini3rdeye]

No protection is used. This seems to happend on any excel spreadsheet on this
computer. Thanks for your response.

 

[JNW]

hmmm...

The only thing I can think is instead of doing a repair, completely
uninstall and install again. Not a very pleasant solution...

 

[ilia]

One possibility is that it was disabled by a workbook via macros. Do
you have macros enabled?

If so, try this. Go to your VBA window (Alt+F11), press Ctrl+G to
open the Immediate window, and type in this command:
?Application.CommandBars.ActiveMenuBar.Controls("Insert").Enabled

Press Enter. If it says "False", type in this:
Application.CommandBars.ActiveMenuBar.Controls("Insert").Enabled =
True

 

[gemini3rdeye]

Thanks for the response, but this did not help. I am going to reinstalled
office in a new folder and remove the old folder to try and fix this problem

 

[ilia]

Does the Immediate window say the Enabled property is true or false?

 

[gemini3rdeye]

It says true. We went ahead and created a new profile for office and the
user is able to use excel with no problems. Thanks again for all of your
input.