grey out insert menu options
 

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.

grey out insert menu options
 

Is the sheet or workbook protected?
--
JNW


"gemini3rdeye" wrote:

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.

grey out insert menu options
 

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

"JNW" wrote:

Is the sheet or workbook protected?
--
JNW


"gemini3rdeye" wrote:

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.

grey out insert menu options
 

hmmm...

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


"gemini3rdeye" wrote:

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

"JNW" wrote:

Is the sheet or workbook protected?
--
JNW


"gemini3rdeye" wrote:

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.

grey out insert menu options
 

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("I nsert").Enabled

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


On Oct 4, 10:32 am, gemini3rdeye
wrote:
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.

grey out insert menu options
 

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
on monday. Thank you all for your advice!

"ilia" wrote:

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("I nsert").Enabled

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


On Oct 4, 10:32 am, gemini3rdeye
wrote:
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.

grey out insert menu options
 

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


On Oct 6, 1:15 pm, gemini3rdeye
wrote:
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
on monday. Thank you all for your advice!



"ilia" wrote:
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("I nsert").Enabled

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

On Oct 4, 10:32 am, gemini3rdeye
wrote:
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.- Hide quoted text -

- Show quoted text -

grey out insert menu options
 

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.

"ilia" wrote:

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


On Oct 6, 1:15 pm, gemini3rdeye
wrote:
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
on monday. Thank you all for your advice!



"ilia" wrote:
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("I nsert").Enabled

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

On Oct 4, 10:32 am, gemini3rdeye
wrote:
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.- Hide quoted text -

- Show quoted text -