Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: How to unhide a hidden macro?

  1. #1
    New Member
    Join Date
    May 2010
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question How to unhide a hidden macro?

    I have an Excel workbook that was created by a former coworker. It includes a macro that, among other things, displays a message box about the 2008 file. The macro runs as soon as the file is opened. I'd like to access that macro to correct the date to 2011 and see what else, if anything, it's doing for me (it doesn't appear to do much). I can find references to creating macros to hide and unhide rows/columns and I found ways to delete all macros in a workbook, but I cannot find anything about unhiding a macro without knowing its name.

    Does anyone know of a way to unhide this macro?

    Thanks!

  2. #2
    Board Regular dave3009's Avatar
    Join Date
    Jun 2006
    Location
    Inverclyde, Scotland
    Posts
    6,996
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How to unhide a hidden macro?

    Press Alt+F11 this will open the VBE, from there you should see a directory of open projects on the left of the screen. Just locate the project you're looking for (it's the same name as the workbook of interest. In there you should be able to see all and any macros that belong to the workbook.
    Please state your version of Excel, I use Excel 2007 on Win 10.
    Back up all data and test VBA code on a COPY workbook, and please use [code][/code] tags.
    HTML Maker | HTML Maker - FAQ

  3. #3
    New Member
    Join Date
    May 2010
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to unhide a hidden macro?

    Thanks, Dave. When I do that, I can see the VBA Project for the workbook. Under that are the Microsoft Excel Objects (14 sheets plus This Workbook) and Modules (Module1 through Module5). As I click each one, I'd expect to see the macro appear on the right, but each of the Objects and Modules appear to be empty.

  4. #4
    Board Regular dave3009's Avatar
    Join Date
    Jun 2006
    Location
    Inverclyde, Scotland
    Posts
    6,996
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How to unhide a hidden macro?

    That's bizarre, I can't think of a feature of excel that would allow such actions without you being able to see the code. Are you able to send the book to me to have a look?
    Please state your version of Excel, I use Excel 2007 on Win 10.
    Back up all data and test VBA code on a COPY workbook, and please use [code][/code] tags.
    HTML Maker | HTML Maker - FAQ

  5. #5
    New Member
    Join Date
    Jan 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to unhide a hidden macro?

    hi Reymond, i refer to your vintage message. did you find any solution for this issue? cause I'm having the same

  6. #6
    Board Regular
    Join Date
    Nov 2017
    Posts
    66
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to unhide a hidden macro?

    I am having a similar issue. I have some macro that was part of an autosave, from a couple years ago that just started to pop back up, i deleted the sheets it was referring to hoping that would stop it, but it doesn't. I to have gone through and don't see any sheets that have any macro or codes running. SO, how can i find this and get rid of it?

  7. #7
    Board Regular
    Join Date
    Jul 2007
    Location
    Sydney
    Posts
    4,276
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How to unhide a hidden macro?

    Hi PlumGr8,

    Sounds like it might be a workbook event macro. Double click on the ThisWorkbook object under the Microsoft Excel Objects heading within the VBE (refer dave3009 post #2 above) and if there's code there either delete or comment it out.

    Robert
    Last edited by Trebor76; Apr 3rd, 2019 at 02:03 AM.

  8. #8
    MrExcel MVP mikerickson's Avatar
    Join Date
    Jan 2007
    Location
    Davis CA
    Posts
    22,348
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    13 Thread(s)

    Default Re: How to unhide a hidden macro?

    What is the message that is shown on start up? Let's suppose that its "Hi. ABC"

    Open the VBEditor and use the Find function to find "Hi. ABC" in the VBProject.

  9. #9
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    8,982
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    2 Thread(s)

    Default Re: How to unhide a hidden macro?

    maybe the code is there but it preceded by a large number - say 200 - blank lines?

    can you check for that within the code modules? such as use the scroll bar, or CTRL-END within the module to go to the end
    If you've posted a clearly explained question & sample data - both input & corresponding output - that can be copied to Excel, THANK YOU.

  10. #10
    Board Regular
    Join Date
    Nov 2017
    Posts
    66
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to unhide a hidden macro?

    I am gonna check hopefully today. It was originally part of an auto-save function that we haven't used in a while since excel does it now. Just randomly started, gonna see if i can find out some more info later today or tomorrow.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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