+ Reply to Thread
Results 1 to 2 of 2

Recalculate Button Macro

  1. #1
    Forum Contributor
    Join Date
    07-29-2009
    Location
    Melbourne, Australia
    MS-Off Ver
    365
    Posts
    255

    Recalculate Button Macro

    hi all,

    trying to create a Recalculate Button Macro in 'summary' sheet in the top button (Allocate Reviewers).

    looked online, should be pretty simple?

    Q
    Attached Files Attached Files
    Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    4,542

    Re: Recalculate Button Macro

    Record Macro > name the macro > OK > press F9 > Stop Recording
    Insert a Shape > right-click the shape > Assign Macro > select the macro you just recorded > OK
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro won't recalculate automatically
    By dtheb in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-05-2014, 04:34 PM
  2. [SOLVED] Macro button copies sheet containing a macro button as an image
    By namso1902 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2013, 03:51 PM
  3. [SOLVED] Macro to recalculate data every minute
    By HFederm2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2013, 12:12 PM
  4. need macro to refresh or recalculate data
    By puneet_pr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2012, 11:03 AM
  5. Macro to recalculate if rand result is negative
    By David.Hauck in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-02-2011, 10:51 AM
  6. A macro to create a form button, assign a macro and name the button
    By cl361 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2008, 01:07 AM
  7. Macro to recalculate function
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2007, 08:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1