Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 24th 12, 04:44 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 6
Default Excel Personal.xlsb file shows up all the time with new spreadsheets

I am using Excel 2007. I wrote a vba macro for just my computer. Now
when I open a new file,
the title in the title bar is "personal.xlsb". How do I go back to
having "sheet1, sheet2, and sheet 3" as the
three tabs in the bottom, instead of being called "personal.xlsb".
Please advise.


  #2   Report Post  
Old March 24th 12, 09:51 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by Tony O[_3_] View Post
I am using Excel 2007. I wrote a vba macro for just my computer. Now
when I open a new file,
the title in the title bar is "personal.xlsb". How do I go back to
having "sheet1, sheet2, and sheet 3" as the
three tabs in the bottom, instead of being called "personal.xlsb".
Please advise.
The "personal.xlsb" workbook will open each time you open Excel, unless there are no macros in it.

As far as I'm aware, your choices are delete the macro if you're no longer using it or hide the personal.xlsb workbook so you don't notice it open.

I tend to use the second approach as I find the macros handy to have available regardless of what I'm working on.
  #3   Report Post  
Old March 25th 12, 12:02 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 621
Default Excel Personal.xlsb file shows up all the time with new spreadsheets

When you wrote the macro you stored it in Personal Macro Workbook.

This workbook opens with Excel and is useful so your macros are
available for all open workbooks.

Hide Personal.xlsb under ViewHide then close Excel............you
will be asked if you want to save changes to
Personal.xlsb..........YES you do want to save.

From now on it will open hidden but your macros will be available
under ViewMacros

More info in Help on this subject.


Gord

On Sat, 24 Mar 2012 08:44:02 -0700 (PDT), Tony O
wrote:

I am using Excel 2007. I wrote a vba macro for just my computer. Now
when I open a new file,
the title in the title bar is "personal.xlsb". How do I go back to
having "sheet1, sheet2, and sheet 3" as the
three tabs in the bottom, instead of being called "personal.xlsb".
Please advise.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
removing personal.xlsb file Lotto[_2_] Excel Programming 1 July 28th 11 01:01 PM
how do I stop PERSONAL.XLSB from showing every time XL opens? Kerry S Excel Discussion (Misc queries) 1 January 2nd 10 03:40 PM
Excel 2007 Personal.XLSB file Marilyn Excel Programming 0 April 14th 09 07:32 PM
personal.xlsb file Alain Excel Discussion (Misc queries) 1 November 4th 07 12:02 PM


All times are GMT +1. The time now is 02:23 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017