Excel 2007 - Personal Macro Workbook 1

[ladyck3]

Ok, so someone please talk to me about this. There was mention in another thread somewhere about a Personal Macro Workbook and I thought hey that's kinda cool. SO I created a *.xlsm workbook and keep it 'map pinned' to my file menu in Excel. I have a couple of macros recorded that I use on a daily basis. When I need them, I open the workbook, run the two macros on the data in my daily workbook and then close the personal file until the next morning. Wash, Rinse, repeat.

Now I'm reading in a book that excel should have a personal macro file by default. Please explain how this happens, how it is used, the particulars. Please.

Thanks!

LadyCK3
aka: Laurie

 

[SkipVought]

Laurie,

FIRST you must create one.

The simplest way that I know of is to RECORD a macro. In the Record Macro window is a Store macro in: drop down. Select Personal Macro Workbook. All you have to do is select a new cell and then STOP the recorder.

This creates the Personal.xlsm workbook, which is HIDDEN and opens each time you Start Excel or open an Excel Workbook.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[ladyck3]

Got it, did it, relocated it, added my two previous macros to this "xlsb" file (2007) and now I'm good to go

If I create more 'every day' macros I can just add them .. works for me

Thanks!

LadyCK3
aka: Laurie

 

[SkipVought]

The most versatile use I have found for the personal macro workbook is universal functions. Most of mine (over 100) return a value from a database (Oracle, DB2) given a parameter that provides a criteria value. I publish these to several dozen people in our organization.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jerem31]

I don't know if I'm in the right area since right above this box is the question "Have your answered this question before?" This is not an answer, it's a question in regards to Personal.xls. In one of the comments in this thread it said that Personal.xls is hidden and opens up upon opening Excel. I have created a Personal.xls and it does indeed open up upon opening Excel, but if I use the worksheet that opens up and start typing in it and save the document, it screws up my Personal.xls. Because of this, I open a new Workbook (let's say Book 1) and then start to use that as my new Excel document. So, essentially what I'm asking is is there any way to have this Personal.xls to indeed be hidden (as was mentioned in this thread) so that when I open Excel I'm not looking at the Personal.xls - I have a document that says Book 1 from the getgo. Hope this makes sense and thanks for your help.

 

[SkipVought]

is is there any way to have this Personal.xls to indeed be hidden (as was mentioned in this thread) so that when I open Excel I'm not looking at the Personal.xls

This is, indeed, how personal.xls SHOULD behave. If it does not, HIDE the personal.xls workbook and be sure you SAVE the pesonal.xls workbook!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jerem31]

Well, thanks for the quick response. How do you hide the Personal.xls? Tried to look that up in Excel Help, but didn't see anything there.

 

[SkipVought]

Windows > Hide

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}