ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why can't I format cells in Excel 2000? (https://www.excelbanter.com/excel-discussion-misc-queries/2956-why-cant-i-format-cells-excel-2000-a.html)

Larry

Why can't I format cells in Excel 2000?
 
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.



Jim Rech

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
"Larry" wrote in message
...
|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.
|
|




All times are GMT +1. The time now is 08:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com