Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot Format areas of a workbook
I am suddenly unable to format ranges of cells on some sheets of a workbook.
The workbook is one I've been using for a long time. There's not anything fancy to the formatting. The used part is only 7 worksheets (4 of which are direct copies of sections of 1 worksheet). I have read other posts re the 4,000 format limit & tried the excel addin & the vba routine from Leo. I do not receive error messages re the format limit. I can format cell ranges on one sheet, but on 2 others I cannot. I can format these 2 sheets only if I use the "Select all" box in the top left corner: then the format menu comes up; otherwise it won't. The sheets are not protected. Any help would be appreciated! Thanks. -- - markvi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Format Cell | Excel Discussion (Misc queries) | |||
Loop time seems dependent on unrelated workbook - Why? | Excel Worksheet Functions | |||
excel exits unexpectedly or hangs the second time I open workbook | Excel Discussion (Misc queries) | |||
Copying the format within a worksheet to all in a workbook | Excel Discussion (Misc queries) | |||
Unprotect Workbook | Excel Discussion (Misc queries) |