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.

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.

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.

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.

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.

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.

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 -

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 -