LinkBack URL
About LinkBacks
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.
Please Login or Register to view this content.
Or loop through each worksheetPlease Login or Register to view this content.
Please Login or Register to view this content.
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)
Posting Permissions
Register To Reply
Bookmarks