andrewb90
Well-known Member
- Joined
- Dec 16, 2009
- Messages
- 1,077
Hello,
I have this code:
Code:
Sub comments1() With ActiveSheet With .Rows("180:186") .Hidden = Not .Hidden End With With .DropDowns("Tag1_1") .Visible = Not .Visible End With With .DropDowns("Tag2_1") .Visible = Not .Visible End With End WithEnd Sub</pre>
Now, when I run this code, sometimes (but oddly not every time) the dropdowns do not reappear where they were originally placed. Is there a solution to this?
Any help would be greatly appreciated.
Thanks,
Andrew
I have this code:
Code:
Sub comments1() With ActiveSheet With .Rows("180:186") .Hidden = Not .Hidden End With With .DropDowns("Tag1_1") .Visible = Not .Visible End With With .DropDowns("Tag2_1") .Visible = Not .Visible End With End WithEnd Sub</pre>
Now, when I run this code, sometimes (but oddly not every time) the dropdowns do not reappear where they were originally placed. Is there a solution to this?
Any help would be greatly appreciated.
Thanks,
Andrew