Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo box
I posted this question to the forum on 14th July but received no reponses, so
I am posting it again. 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo box
Hi
Question is not clear, can you please mal me with example file to "R Ormerod" wrote: I posted this question to the forum on 14th July but received no reponses, so I am posting it again. 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo box
Unfortunately for reasons of confidentiality I cannot send you the example
file. I shall try and explain the combo box in more detail: = It is embedded in the main report worksheet which users interact with = In Properties the ListFillRange is linked to another worksheet with a list of customers = All cells in the main report worksheet refer to a cell which changes the customer details when the user picks another from the drop-down list and then extract data from a variety of other worksheets in the file = In addition there is a Private Sub ComboBox1_Change() set up which re-keys formulae every time the combo box changed for certain cells in the main report worksheet which are unprotected and can be used to input data into the file Changing the customer in the combo box works when all worksheets in the file are unhidden. However, I like to present the file to other users with all the various data worksheets hidden. When this is done, changing the combo box causes all hidden rows in the main report worksheet to be unhidden, disrupting the formatting. This has not happened before and there is no VBA code in the Private Sub ComboBox1_Change() to unhide rows, so can you think of any other cause which may lead to this outcome? -- R Ormerod "Muhammed Rafeek M" wrote: Hi Question is not clear, can you please mal me with example file to "R Ormerod" wrote: I posted this question to the forum on 14th July but received no reponses, so I am posting it again. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best way to populate worksheet from 2 combo boxes | Excel Worksheet Functions | |||
Macro that can run combo boxes | Excel Discussion (Misc queries) | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions |