Hello,
So, I have a question if you have ever encountered this, if it's normal or how to solve this problem. I am new to macros, and for my project in work I have a table with information. However, this table is important for three different departments, and every department needs different data. So I have created three toggle buttons to hide/unhide relevant info, depending on which button you click. And the code works and the buttons do what they should except, I have to scroll the page sideways a bit, in order to ''activate'' the button. Basically what happens is: I click button, nothing happens, I hold the bottom side scroller to scroll a bit to the right, the button unlocks and I can click it all I like. To make another button work, I have to click this button, nothing happens, scroll page to the right, button unlocks and then it works.
The thing is that it's super annoying and I don't think I will be able to explain it to everybody who will be using the table.
Have you ever seen anything like this?
Thank you.
So, I have a question if you have ever encountered this, if it's normal or how to solve this problem. I am new to macros, and for my project in work I have a table with information. However, this table is important for three different departments, and every department needs different data. So I have created three toggle buttons to hide/unhide relevant info, depending on which button you click. And the code works and the buttons do what they should except, I have to scroll the page sideways a bit, in order to ''activate'' the button. Basically what happens is: I click button, nothing happens, I hold the bottom side scroller to scroll a bit to the right, the button unlocks and I can click it all I like. To make another button work, I have to click this button, nothing happens, scroll page to the right, button unlocks and then it works.
The thing is that it's super annoying and I don't think I will be able to explain it to everybody who will be using the table.
Have you ever seen anything like this?
Thank you.