Placing an "Execute" button in Excel...

[ltipto1]

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?

[Andy Pope]

Add a button from the Forms toolbar. Assign this macro to it.

Please Login or Register  to view this content.

If you want the workbook to recalculate you will need to use the following, but it will do all open workbooks.

Please Login or Register  to view this content.

Or loop through each worksheet

Please Login or Register  to view this content.