XL '02
In my workbook I have multiple sheets with generally 90% of the cells locked & hidden under sheet protection invoking "Select unlocked cells" [the only permission checked] . Most sheets allow cell highlight with selection, that's perfect.
But, my primary sheet will allow cell selection [of unlocked cells] but will not highlight the cells. This sheet does have about 25 dropdowns from Control Toolbox with their underlying cells unlocked for proper function. The sheets providing cell highlights do not have any dropdowns. This is the only difference I can see between all the sheets.
Anyone have a clue to why this is happening?
Bookmarks