ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help! Selecting item on data validation list switches windows (https://www.excelbanter.com/excel-discussion-misc-queries/74463-help-selecting-item-data-validation-list-switches-windows.html)

Kevlar

Help! Selecting item on data validation list switches windows
 

I'm using data validation using a named range list. Whenever I select an
item from the drop down list, it switchs to another tab in the workbook.
I've checked my VBA code and there is no reference to that list or cell.
This is very annoying. :mad: Does anyone have any ideas? :confused:

Oh!, by the way, it randomly happens, something is turning this off and
on. Usually after I've clicked on it several times it stops behaving
this way.


--
Kevlar
------------------------------------------------------------------------
Kevlar's Profile: http://www.excelforum.com/member.php...fo&userid=7231
View this thread: http://www.excelforum.com/showthread...hreadid=517533



All times are GMT +1. The time now is 09:35 AM.

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