I found this great macro which adjusts the height of cells when a worksheet is activated (see macro below). I would like to activate the macro from a command button on a different worksheet within the same workbook, but I cannot get it to work. I tried adding the macro to a "Private Sub CommandButton1_Click()" function and included a line to activate the correct worksheet but it doesn't seem to work
THE ORIGINAL CODE THAT WORKS
THE UPDATED CODE THAT DOESN"T WORKPlease Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks