+ Reply to Thread
Results 1 to 3 of 3

How to save a macro in the personal.xlsb folder

  1. #1
    Registered User
    Join Date
    04-12-2014
    Location
    Kemp, Texas
    MS-Off Ver
    Excel 2010
    Posts
    10

    How to save a macro in the personal.xlsb folder

    After I record a macro, no option appears to save the macro in the personal.xlsb file. How would I save it for use from any workbook?
    Where is the XLStart folder? Is that set up by the system or do I set it up someplace?

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: How to save a macro in the personal.xlsb folder

    The macro is saved as long as the file type can run macros.

    In Excel look for the programmer option, view code, worksheet option it will give you options on the triggrers...

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: How to save a macro in the personal.xlsb folder

    Hi, ajan,

    I must decide prior to recording a macro where to store it - but any macro may be copied over to any workbook if you enter the VBE and copy within the project explorer. For the personla workbook: start recording a macro, choose persopnal workbook, stop, save the workbook when exiting Excel.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ 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] Personal.xlsb Macro Naming Format
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-23-2014, 04:20 PM
  2. cannot run macro if personal.xlsb is hidden
    By illusionek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2014, 08:16 AM
  3. Add procedure to PERSONAL.XLSB with a macro from another workbook.
    By dimattia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2013, 10:21 AM
  4. How to save code under VBAProject(PERSONAL.XLSB) that applies to any workbook
    By bubai in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2013, 08:01 AM
  5. DELETE the Personal.XLSB macro I created - can't get rid of it!
    By Cut2please in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2013, 07:51 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