I have a need to place a button on an Excel spreadsheet that would allow a user to fill in some information, THEN press "Execute" for the spreadsheet to recalculate.
How is the best way to do this?
I have a need to place a button on an Excel spreadsheet that would allow a user to fill in some information, THEN press "Execute" for the spreadsheet to recalculate.
How is the best way to do this?
Add a button from the Forms toolbar. Assign this macro to it.
If you want the workbook to recalculate you will need to use the following, but it will do all open workbooks.![]()
Sub RecalcSheet() activesheet.calculate End Sub
Or loop through each worksheet![]()
Application.Calculate
![]()
Sub RecalcSheet() dim shtTemp as worksheet for each shttemp in activeworkbook.worksheets shttemp.calculate next End Sub
Last edited by Andy Pope; 06-19-2009 at 04:51 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks