Hello Everyone,
I apologize in advance if this is somewhere else on the forum, but I could not find it. I am making a workbook at work which pulls on the data from other workbooks, so that we can see our monthly totals for various categories. What I tried to do (but could not figure it out) is have an autoshape button that, when clicked, would run the macro to update all the links in the worksheet, thus updating all the numbers. Any help that you guys can give is greatly appreciated.
Ryan
P.S. - For what it's worth, here's what I have in VBA for the autoshape:
Sub AutoShape6_Click()
ThisWorkbook.UpdateLinks = xlUpdateLinksAlways
End Sub
I apologize in advance if this is somewhere else on the forum, but I could not find it. I am making a workbook at work which pulls on the data from other workbooks, so that we can see our monthly totals for various categories. What I tried to do (but could not figure it out) is have an autoshape button that, when clicked, would run the macro to update all the links in the worksheet, thus updating all the numbers. Any help that you guys can give is greatly appreciated.
Ryan
P.S. - For what it's worth, here's what I have in VBA for the autoshape:
Sub AutoShape6_Click()
ThisWorkbook.UpdateLinks = xlUpdateLinksAlways
End Sub
