ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combo box (https://www.excelbanter.com/excel-discussion-misc-queries/99315-combo-box.html)

R Ormerod

Combo box
 
I have a macro set up which runs through its commands every time a combo box
in the worksheet is changed.

If I change the combo box with all the source data worksheets hidden then
for some reason hidden rows in that worksheet are unhidden. There is no VBA
code which specifies this.

If all worksheets are unhidden, changing the combo box does not unhide rows
and the macro works normally.

What could be causing this?

--
R Ormerod


All times are GMT +1. The time now is 02:19 AM.

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