+ Reply to Thread
Results 1 to 13 of 13

What is this macro?

  1. #1
    Registered User
    Join Date
    11-28-2017
    Location
    Spokane, Washington, USA
    MS-Off Ver
    Microsoft Excel for Mac version 15.4
    Posts
    6

    What is this macro?

    Hi!

    I found a thread that addresses exactly what I need, but in my excel for Mac version 15.4 I cannot actually view the macro. I would like to know exactly what I am using in this workbook, as it will be edited by multiple people of varying excel proficiency.

    This is the thread that provides the Macro: https://www.excelforum.com/excel-pro...-workbook.html

    I can download the workbook and it does exactly what I want it to do, but I cannot view the macro. Please help!

    Thank you,
    TK

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: What is this macro?

    Right-click the first tab and select View Code.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: What is this macro?

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    11-28-2017
    Location
    Spokane, Washington, USA
    MS-Off Ver
    Microsoft Excel for Mac version 15.4
    Posts
    6

    Re: What is this macro?

    Thank you so much for your swift response!

    I apologize for being obtuse, but I think I need a little more help! I clicked "view code," but I couldn't find anything on that screen pertaining to the macro. (I didn't even find anything that resembled code...)

    What I need is something that is going to tell me step by step how to recreate the macro, preferably beginning with the step "click record macro."

    Any further help would be greatly appreciated!

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: What is this macro?

    Hi

    Did you try double-clicking each sheet in the VB Editor?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  6. #6
    Registered User
    Join Date
    11-28-2017
    Location
    Spokane, Washington, USA
    MS-Off Ver
    Microsoft Excel for Mac version 15.4
    Posts
    6

    Re: What is this macro?

    I see. When I do that it DOES show me the code, but I still don't know what to do with it. If I copy and paste it into a different workbook it doesn't perform the same function that it does in the original.

    What should I do with this code? My end goal is to be able to replicate the same results that I am getting in the test document.

    Thank you for all the help so far!

  7. #7
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: What is this macro?

    The code must go into a worksheet code module so after copying it, use the View code trick on the sheet in the other workbook and then paste the code into that module.

  8. #8
    Registered User
    Join Date
    11-28-2017
    Location
    Spokane, Washington, USA
    MS-Off Ver
    Microsoft Excel for Mac version 15.4
    Posts
    6

    Re: What is this macro?

    I pasted it into the same screen I copied it out of, just in the different workbook, but it isn't doing anything.

    I guess what I need is to learn how to interpret the VBA coding language. That might be my downfall here. :-/

  9. #9
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: What is this macro?

    Assuming it is in the right place, the code runs automatically when you activate the relevant worksheet.

  10. #10
    Registered User
    Join Date
    11-28-2017
    Location
    Spokane, Washington, USA
    MS-Off Ver
    Microsoft Excel for Mac version 15.4
    Posts
    6

    Re: What is this macro?

    Nothing is happening in the worksheet. I think if I figure out the coding language I'll find where my problem lies.

    This was supposed to be such a simple project!

  11. #11
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: What is this macro?

    A picture may help, as mentioned before, right click on the sheet tab and select "View Code", that is the worksheet module.
    RightClickTab.jpg

    Doing a quick web search, I have found that this is not as uncommon a question as one would think. (could this be a MAC issue?)
    Last edited by davesexcel; 11-29-2017 at 02:58 PM.

  12. #12
    Registered User
    Join Date
    11-28-2017
    Location
    Spokane, Washington, USA
    MS-Off Ver
    Microsoft Excel for Mac version 15.4
    Posts
    6

    Re: What is this macro?

    Here's where I'm stuck:

    I've found and copied this code: Screen Shot 2017-11-29 at 10.57.00 AM.png

    And pasted it here: Screen Shot 2017-11-29 at 10.57.37 AM.png

    And the workbook is behaving as if I have done nothing at all.

    I've also discovered that the original download does not allow you to add sheets and have the master sheet automatically update with this information too, so I'm a little more stuck than I thought I was.

    I need to be able to have many contact sheets automatically update one master contact sheet, and I need to know how this is being done so that if something goes sideways, I can fix the problem.

    Thank you all for your patience and continued efforts to help me figure this out!

  13. #13
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: What is this macro?

    You've put the code into the ThisWorkbook module judging from that picture. It must be in a worksheet module.

+ 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. [SOLVED] Macro to add another Macro to a button to add into a larger Macro.
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2016, 10:51 AM
  2. [SOLVED] Define variable in macro than calling that macro inside another macro
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2015, 10:58 AM
  3. Using a macro on workbook1 to create a button in wb2 and assigning macro "wb2!macro"
    By penfold1992 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2014, 11:39 AM
  4. [SOLVED] Macro to show Which macro didnt work in a nested macro
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-10-2013, 03:21 AM
  5. Perform macro "on open" specific file- store macro in Personal Macro Workbook?
    By thompssc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 12:38 PM
  6. lookup macro, solver macro, realtime macro
    By xelhelp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2011, 06:14 PM
  7. Cannot find macro error when running a macro from a macro in a diffrent workbook.
    By Acrobatic82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 09:22 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