ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why hand pointer in one and not the other (https://www.excelbanter.com/excel-discussion-misc-queries/106275-why-hand-pointer-one-not-other.html)

David

Why hand pointer in one and not the other
 
I have two workbooks identical in every way but with different names.
I have data validation set up identically in both
When I click one of those cells in one, I get a hand pointer that will open
the list. Not so in the other. I've examined all Tools|Options, row heights
and column widths, etc. between the two and see no difference in settings.

Can anyone explain?

--
David

David

Why hand pointer in one and not the other
 
Aha! I had Sheet Protection for objects set on one and not the other.

--
David

David wrote

I have two workbooks identical in every way but with different names.
I have data validation set up identically in both
When I click one of those cells in one, I get a hand pointer that will
open the list. Not so in the other. I've examined all Tools|Options,
row heights and column widths, etc. between the two and see no
difference in settings.

Can anyone explain?




All times are GMT +1. The time now is 10:47 PM.

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