Group:  Microsoft Excel » microsoft.public.excel.programming
Thread: Personal macro workbook

Geek News

Personal macro workbook
ketanvmehta[ at ]gmail.com 12/31/2008 8:01:30 AM
I have just installed excel 2007 and kepping excel 2003 also.

Now whenever I open Excel2003 or 2007, personal.xls opens and shows
visibali on my start bar.
Earlier it was not showing.

Can anybody help please?

Thanks.
Ketan
Re: Personal macro workbook
Dave Peterson <petersod[ at ]verizonXSPAM.net> 12/31/2008 2:14:59 PM
Open xl2003
Make sure that personal.xls is active
window|hide
close excel and answer yes to the save prompt.

If you're using a separate personal.xls (personal.xlsm???) in xl2007, then
there's an option to hide the window somewhere on the ribbon.

ketanvmehta[ at ]gmail.com wrote:
[Quoted Text]
>
> I have just installed excel 2007 and kepping excel 2003 also.
>
> Now whenever I open Excel2003 or 2007, personal.xls opens and shows
> visibali on my start bar.
> Earlier it was not showing.
>
> Can anybody help please?
>
> Thanks.
> Ketan

--

Dave Peterson
Re: Personal macro workbook
"Ron de Bruin" <rondebruin[ at ]kabelfoon.nl> 12/31/2008 4:03:44 PM
Hi Dave and Ketan

[Quoted Text]
> If you're using a separate personal.xls (personal.xlsm???) in xl2007
It is xlsb in 2007

What to do if your PERSONAL.XLS(B) is visible

When you open Excel and you see PERSONAL.XLS(B) in the title bar you can use this to hide it.

Excel 97-2003: Window>Hide
Excel 2007 : On the View tab in the window group choose Hide

Then close Excel and say Yes to save the changes to your PERSONAL file.


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" <petersod[ at ]verizonXSPAM.net> wrote in message news:495B7E63.D362AD35[ at ]verizonXSPAM.net...
> Open xl2003
> Make sure that personal.xls is active
> window|hide
> close excel and answer yes to the save prompt.
>
> If you're using a separate personal.xls (personal.xlsm???) in xl2007, then
> there's an option to hide the window somewhere on the ribbon.
>
> ketanvmehta[ at ]gmail.com wrote:
>>
>> I have just installed excel 2007 and kepping excel 2003 also.
>>
>> Now whenever I open Excel2003 or 2007, personal.xls opens and shows
>> visibali on my start bar.
>> Earlier it was not showing.
>>
>> Can anybody help please?
>>
>> Thanks.
>> Ketan
>
> --
>
> Dave Peterson
Re: Personal macro workbook
Dave Peterson <petersod[ at ]verizonXSPAM.net> 12/31/2008 5:28:30 PM
Thanks Ron.

Ron de Bruin wrote:
[Quoted Text]
>
> Hi Dave and Ketan
>
> > If you're using a separate personal.xls (personal.xlsm???) in xl2007
> It is xlsb in 2007
>
> What to do if your PERSONAL.XLS(B) is visible
>
> When you open Excel and you see PERSONAL.XLS(B) in the title bar you can use this to hide it.
>
> Excel 97-2003: Window>Hide
> Excel 2007 : On the View tab in the window group choose Hide
>
> Then close Excel and say Yes to save the changes to your PERSONAL file.
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
> "Dave Peterson" <petersod[ at ]verizonXSPAM.net> wrote in message news:495B7E63.D362AD35[ at ]verizonXSPAM.net...
> > Open xl2003
> > Make sure that personal.xls is active
> > window|hide
> > close excel and answer yes to the save prompt.
> >
> > If you're using a separate personal.xls (personal.xlsm???) in xl2007, then
> > there's an option to hide the window somewhere on the ribbon.
> >
> > ketanvmehta[ at ]gmail.com wrote:
> >>
> >> I have just installed excel 2007 and kepping excel 2003 also.
> >>
> >> Now whenever I open Excel2003 or 2007, personal.xls opens and shows
> >> visibali on my start bar.
> >> Earlier it was not showing.
> >>
> >> Can anybody help please?
> >>
> >> Thanks.
> >> Ketan
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson
Re: Personal macro workbook
ketanvmehta[ at ]gmail.com 12/31/2008 6:23:46 PM
On Dec 31, 10:28 pm, Dave Peterson <peter...[ at ]verizonXSPAM.net> wrote:
[Quoted Text]
> Thanks Ron.
>
>
>
>
>
> Ron de Bruin wrote:
>
> > Hi Dave and Ketan
>
> > > If you're using a separate personal.xls (personal.xlsm???) in xl2007
> > It is xlsb in 2007
>
> > What to do if your PERSONAL.XLS(B) is visible
>
> > When you open Excel and you see PERSONAL.XLS(B) in the title bar you can use this to hide it.
>
> > Excel 97-2003: Window>Hide
> > Excel 2007     : On the View tab in the window group choose Hide
>
> > Then close Excel and say Yes to save the changes to your PERSONAL file.
>
> > --
>
> > Regards Ron de Bruin
> >http://www.rondebruin.nl/tips.htm
>
> > "Dave Peterson" <peter...[ at ]verizonXSPAM.net> wrote in messagenews:495B7E63.D362AD35[ at ]verizonXSPAM.net...
> > > Open xl2003
> > > Make sure that personal.xls is active
> > > window|hide
> > > close excel and answer yes to the save prompt.
>
> > > If you're using a separate personal.xls (personal.xlsm???) in xl2007, then
> > > there's an option to hide the window somewhere on the ribbon.
>
> > > ketanvme...[ at ]gmail.com wrote:
>
> > >> I have just installed excel 2007 and kepping excel 2003 also.
>
> > >> Now whenever I open Excel2003 or 2007, personal.xls opens and shows
> > >> visibali on my start bar.
> > >> Earlier it was not showing.
>
> > >> Can anybody help please?
>
> > >> Thanks.
> > >> Ketan
>
> > > --
>
> > > Dave Peterson
>
> --
>
> Dave Peterson- Hide quoted text -
>
> - Show quoted text -

Hi,
Thanks to both of you.
Ketan

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net