Just a minor question. I have created a macro which involves the deletion and shifting of some columns. In the excel spreadsheet I have a button to execute the macro. The problem is that when I press the button to execute the program which involves the shifting of columns, the button also shifts as a consequence as well, since its located on the same sheet (Sheet1) where the columns are shifted. Is there a way to create a button that will not move when columns are shifted? or not be impacted by the shift? no matter where I put the button on sheet1 just the fact that columns are deleted and the remaining ones shift to the left automatically moves the button to the left as well. Thanks in advance.
Reply With Quote
