+ Reply to Thread
Results 1 to 7 of 7

Where is Personal Macro Workbook on Main VB Screen?

  1. #1
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    Where is Personal Macro Workbook on Main VB Screen?

    Where is Personal Macro Workbook on main Visual Basic screen?

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Where is Personal Macro Workbook on Main VB Screen?

    It's hidden, if it exists - It doesn't exist until you record a macro to it.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Where is Personal Macro Workbook on Main VB Screen?

    It would be visible in the Project Explorer window.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  4. #4
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    Re: Where is Personal Macro Workbook on Main VB Screen?

    What's the name of it when it's created?

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Where is Personal Macro Workbook on Main VB Screen?

    Its name is "Personal"

  6. #6
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    Re: Where is Personal Macro Workbook on Main VB Screen?

    The file called "Personal" doesn't exist even I create modules. Where is it?

  7. #7
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Where is Personal Macro Workbook on Main VB Screen?

    Inserting a Module doesn't create it. Record a Macro. Then go into the VBE. Over too your lefthand side under Project - VBA Project you'll see it is one of the selections.

+ 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. Running workbook macro from personal workbook
    By mashley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2009, 08:44 AM
  2. No Personal Macro Workbook?
    By Kou Vang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2006, 01:10 PM
  3. [SOLVED] Macro to link Sheets to main workbook
    By raven_guy in forum Excel General
    Replies: 0
    Last Post: 06-24-2005, 08:05 AM
  4. Personal macro workbook and personal.xls
    By John Kilkenny in forum Excel General
    Replies: 1
    Last Post: 06-14-2005, 05:05 PM
  5. [SOLVED] Personal.XLS MACRO Workbook
    By Don in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-10-2005, 08:06 PM

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