Dealing wiht the Personal.xlsx workbook

[Burrgogi]

Working with Office 2007.

I personally don't like how the Personal.xlsx shows up maximized every time I start up Excel application. So I wrote a very simple VBA event routine. Here it is:

Private Sub Workbook_Open()
    ThisWorkbook.Windows(1).WindowState = xlMinimized
    Workbooks.Add
End Sub

The reason is that sometimes when I'm a hurry, I end up typing "various stuff" on the personal.xlsx worksheet and I think that's a bad habit. So the macro puts the new workbook in front of my face and I can start typing away without having to worry about my personal.xlsx.

Only problem with the code is that the new workbook does not show up in a maximized state. I therefore added:

Workbooks(1).Windows(1).WindowState = xlMaximized

Just before the End Sub.

Now the strange thing is that the Personal.xlsx seems to be keep reasserting itself and it's in front of my face all the time now!

Any suggestions on a solution?

 

[SuperFerret]

Re: Dealing with the Personal.xlsx workbook

Can you not just hide it?

When it opens: View > Hide

I got annoyed by that so mine is hidden unless I need to amend something.

 

[Andrew Poulsom]

Re: Dealing with the Personal.xlsx workbook

The workbook should be named PERSONAL.XLSB and it should be hidden. You may find this helpful:

http://www.rondebruin.nl/personal.htm

 

[SuperFerret]

Darn! So close!

 

[Burrgogi]

Re: Dealing with the Personal.xlsx workbook

The workbook should be named PERSONAL.XLSB and it should be hidden. You may find this helpful:

http://www.rondebruin.nl/personal.htm

Thanks Andrew. I actually made a typo error when I posted my question. It's already named as "PERSONAL.XLSB"

I think I had actually tried to 'hide' the workbook about a couple of months ago and I ran into a strangeness that i couldn't solve. When I made my personal workbook hidden, I couldn't see any of my macros. But today it seems to be working as designed.

Problem solved..... thanks guys.

 

[Burrgogi]

Darn! So close!

Superferret, we haven't heard from Kashif - I wonder if my ahemm...."expertise" was too much for that poor fellow. I should have dumbed it down so he could understand it better eh?