Hi,
Is there a way to keep ActiveX Toggle buttons visible even when you hide the columns where you put them?
John
Hi,
Is there a way to keep ActiveX Toggle buttons visible even when you hide the columns where you put them?
John
Last edited by jdo358; 03-29-2020 at 06:01 PM.
When I hide a column where an ActiveX toggle button is located, the button stays visible. Can you describe in detail what steps you take that lead the button to become invisible?
Move and size with cell property of object must be switched to don't move and size.
Well, it's not that complicated.. . I created three Togglebuttons, and put them in the left top corner of my sheet (cell B1 / C1). Columns B and C are locked. When I hide these columns, only the right togglebutton will stay visible. The other buttons are hided with the column. I compared the properties of the button staying visible with the other buttons, but didn't find a difference.
Hm.. can't find these attributes in the toggle button properties. I'm quite new to Excel VBA so can you a bit more specific please?
Strange
30-03-2020 0-29-32.jpg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks