grey out insert menu options

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
No protection is used. This seems to happend on any excel spreadsheet on this
computer. Thanks for your response.
 
hmmm...

The only thing I can think is instead of doing a repair, completely
uninstall and install again. Not a very pleasant solution...
 
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
 
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
 
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.
 

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

Subtotal function is greyed-out - can't insert 3
Series fill only copying and fill series greyed out 1
Grey out cell 13
Hyperlink option is greyed out 4
Sub Totals option greyed out 1
CF to grey out the two unused options 7
Enable the Options button from the Tools Menu 2
Insert options 1

Back
Top