Why can't I format cells in Excel 2000?

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

Guest

I am working with a spreadsheet I created a year ago. When I right mouse
click on a cell to change the format, nothing happens.
 
If the problem is that the Cell menu is disabled you can re-enable it with a
macro:

Commandbars("Cell").Enabled = True

If you're not familiar with macros you might try renaming your toolbar file
(where "customizations" are kept). With Excel closed find you XLB file (For
Excel 2000 typically EXCEL.XLB in C:\Documents and Settings\<your user
name>\Application Data\Microsoft\Excel) and rename it.

--
Jim Rech
Excel MVP
|I am working with a spreadsheet I created a year ago. When I right mouse
| click on a cell to change the format, nothing happens.
|
|
 

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

Back
Top