Hi,
I'm hoping there is some easy solution to this issue because I have literally spent hours trying to figure this out with not a bit of success.
ISSUE:
I have a sheet that has a ListBox on it. A button shows and hides this ListBox. When I open the document, the ListBox is hidden. I select the button to show the ListBox and I am not able to click into it. If I jump around into different sheets and back into the sheet containing the ListBox, I can then click into it. The ListBox isn't locked and is enabled.
I've even tried adding code to jump between sheets and unless I do it manually, it has no effect.
Any ideas?
- Adam
I'm hoping there is some easy solution to this issue because I have literally spent hours trying to figure this out with not a bit of success.
ISSUE:
I have a sheet that has a ListBox on it. A button shows and hides this ListBox. When I open the document, the ListBox is hidden. I select the button to show the ListBox and I am not able to click into it. If I jump around into different sheets and back into the sheet containing the ListBox, I can then click into it. The ListBox isn't locked and is enabled.
I've even tried adding code to jump between sheets and unless I do it manually, it has no effect.
Any ideas?
- Adam