| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where is Personal Macro Workbook?
Hello, I wanted to edit a macro, but Excel told me my personal macro workbook was hidden and I needed to unhide it. Where the heck is it? TIA -F -- fxcel ------------------------------------------------------------------------ fxcel's Profile: http://www.excelforum.com/member.php...o&userid=24864 View this thread: http://www.excelforum.com/showthread...hreadid=552909 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where is Personal Macro Workbook?
If you created personal.xls, then you can have excel tell you where it was
saved. Open excel hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window. type this and hit enter: ?workbooks("Personal.xls").path to get the drive/folder where it's stored. ?workbooks("Personal.xls").FullName will include the name, too. If you get some type of error message (and you did type stuff correctly), then you didn't create that personal.xls workbook. fxcel wrote: Hello, I wanted to edit a macro, but Excel told me my personal macro workbook was hidden and I needed to unhide it. Where the heck is it? TIA -F -- fxcel ------------------------------------------------------------------------ fxcel's Profile: http://www.excelforum.com/member.php...o&userid=24864 View this thread: http://www.excelforum.com/showthread...hreadid=552909 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Where is Personal Macro Workbook?
You don't need to find it if you just want to edit the macros. Click on
ToolsMacroMacros...and select the macro in the list and press edit or press Alt+F11 and select the modules below the personal.xls entry. (If there isn't a personal.xls entry...you don't have one) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "fxcel" wrote in message ... Hello, I wanted to edit a macro, but Excel told me my personal macro workbook was hidden and I needed to unhide it. Where the heck is it? TIA -F -- fxcel ------------------------------------------------------------------------ fxcel's Profile: http://www.excelforum.com/member.php...o&userid=24864 View this thread: http://www.excelforum.com/showthread...hreadid=552909 |
| 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) | |||
Linear Mode
