Hello,
I am currently creating a spreadsheet that includes buttons for macro and text boxes for instructions/explanations, and I stumbled upon an isssue.
While running some of the macros, it will hide all useless columns of data (using EntireColumn.Hidden = True).
I cannot predict which columns will be hidden, as it is project dependent.
Sometimes, the buttons to run those macros are located on the columns that get hidden, meaning as soon as a macro is ran, the buttons disappear!
Is there a way to dissociate the buttons and text boxes from the cells, so that even if the columns get hidden, the buttons and text boxes remain at the same location and visible for the user?
Thank you!
Bookmarks