Share via

How do I edit macro code stored in my personal macro workbook?

Anonymous
2014-11-11T16:57:59+00:00

Split from this thread.

Hi Jim, sounds like just want I want, too. Would you mind showing me how do I edit the macro once I stored it into my personal macro workbook?

If I go to Tools->Macros->click on the PasteValues macro->click "edit", it tells me I cannot edit a hidden macro/workbook. 

Then I went to Tools->Macros->Visual Basic Editor. From there I can see the personal macro workbook but can't find the macro.

Thanks a lot in advance.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2014-11-16T03:27:46+00:00

    There are several ways to get at your Personal Macro Workbook macros. 

    One way is to go to Tools > Macro > Macros. In the resulting dialog, select the macro you want to edit and then click the Edit button.

    Another way is to go to the Visual Basic Eidtor. In the Projects window click the disclosure triangle for your Personal Macro Workbook, then look for the Modules folder and double click on the Module.

    The Unhide command you need is on the Window menu, not the Format menu.

    5 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-11-29T16:08:37+00:00

    Hi Jim, thanks for the response. Sorry for late reply. I was occupied elsewhere.

    From VBAProject(Personal Macro Workbook) -> Modules -> Module1, I now notice I need to doubleclick that Module1 to get the code to show up. This gets me to what I need. Thanks for that.

    I now also understand what you mean by Windows->Unhide and have been able to unhide the Personal Macro Workbook to go the Tools->Macro->Macros->Edit path.

    Thanks a lot. Much appreciated.

    0 comments
  2. Anonymous
    2014-11-12T15:13:06+00:00
    0 comments