Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Personal Macro Workbook
I created new macros for a worksheet and ran them. Later I came back so I
could edit them by copying part of one and placing it in another one. I could not find my Personal Macro Workbook. It would not give me the option to open it when I came to the window the displays the Macro names. How do I find this workbook and the macros that I created? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Personal Macro Workbook
The personal.xls file is usually hidden from view. It is also usually and
should be resident in the XLStartup folder usually under your Program Directory of MSO- Excel. If you have Excel open currently Click on the Menu, WIndow, Unhide.. if you see Personal then click on it to unhide it. Once it is open (and you are viewing the Spreadsheet - Do Alt-F11 which should take you to the VBE. Good luck.. Jim May Do a search for the file Personal.xls -- Once youAs long as you save "Frustrated" wrote: I created new macros for a worksheet and ran them. Later I came back so I could edit them by copying part of one and placing it in another one. I could not find my Personal Macro Workbook. It would not give me the option to open it when I came to the window the displays the Macro names. How do I find this workbook and the macros that I created? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Personal Macro Workbook
It may also be that you put those macros into the workbook you had open at
the time and not into personal.xls. If you don't find personal.xls as Jim May has recommended and told how to find, then look in the workbook that was open when you created the macros - open the workbook and use [Alt]+[F11] to get into the VB Editor and peek around to see if they are in that workbook. "Frustrated" wrote: I created new macros for a worksheet and ran them. Later I came back so I could edit them by copying part of one and placing it in another one. I could not find my Personal Macro Workbook. It would not give me the option to open it when I came to the window the displays the Macro names. How do I find this workbook and the macros that I created? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a macro to create a macro in another workbook | Excel Worksheet Functions | |||
How can I get a validation to run in a macro on a shared workbook? | Excel Discussion (Misc queries) | |||
macro save a workbook whilst increasing file no | Excel Worksheet Functions | |||
macro to browse for workbook, pick up data and looping | Excel Worksheet Functions | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |