Prev: STDEDU.MSI not on my CD, needed for XP's sp-3 Update
Next: Error 1309 When Starting Office 2003 Program
From: Parker on 26 Aug 2005 09:26
Hello All,

I have a client that when opening Excel from the shortcut on the desktop it
opens a "personal" file(named at the top next to Excel in the Program title)
that she didn't create, that can contain multiple macros?!?. If they click
on file then new the new workbook will then open fine. There is nothing in
the xlstart folder. Using Office 2000 Pro on Xp Pro. Any Idea how this
happened and how to stop it from opening this way?

Thank You for Any Responses In Advance


From: George Nicholson on 26 Aug 2005 18:58
Some thoughts (running Office XP):
1) Right click on the shortcut and review it's properties. Make sure its
pointing to the Excel application and not Personal.xls.
2) Within Excel: Tools>Options>General: Is there anything filled in under
"At Startup, open all files in:"? If so, this acts as a secondary xlStart
folder. Either clear the setting or remove Personal.xls from that location
(assuming it's there).
3) Do a File search for "Personal.xl*" from Windows Explorer. If found on a
local machine you can probably consider deleting it. If on a network drive,
you may not have an option to delete in which case you'll still have to find
out why it's opening on startup.

Note: There can be more than one XLstart folder (Documents and
Settings\CurrentUser\ApplicationData\Microsoft\Excel\XLstart, etc.as well as
ProgramFiles\Office\Office10\\XLstart), but a file search should point that
out if that's the issue.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Parker" <nospam(a)nospam.com> wrote in message
news:e%23uJ6GkqFHA.1444(a)TK2MSFTNGP10.phx.gbl...
> Hello All,
>
> I have a client that when opening Excel from the shortcut on the desktop
> it opens a "personal" file(named at the top next to Excel in the Program
> title) that she didn't create, that can contain multiple macros?!?. If
> they click on file then new the new workbook will then open fine. There
> is nothing in the xlstart folder. Using Office 2000 Pro on Xp Pro. Any
> Idea how this happened and how to stop it from opening this way?
>
> Thank You for Any Responses In Advance
>


From: Beth Melton on 27 Aug 2005 11:12
If you record a macro in Excel there is an option to store in
"Personal macro workbook". If this is selected the Personal.xls is
created and placed in the XLStart folder. Typically this workbook
opens as a hidden window and you never see it. However if it was
unhidden and saved then when Excel starts you will see the workbook.

Either hide the workbook by going to Window/Hide or remove it from the
XLStart folder. Note the XLStart folder that is used could be found in
the user profile (Documents and Settings), rather than in the Office
installation path.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"Parker" <nospam(a)nospam.com> wrote in message
news:e%23uJ6GkqFHA.1444(a)TK2MSFTNGP10.phx.gbl...
> Hello All,
>
> I have a client that when opening Excel from the shortcut on the
> desktop it opens a "personal" file(named at the top next to Excel in
> the Program title) that she didn't create, that can contain multiple
> macros?!?. If they click on file then new the new workbook will
> then open fine. There is nothing in the xlstart folder. Using
> Office 2000 Pro on Xp Pro. Any Idea how this happened and how to
> stop it from opening this way?
>
> Thank You for Any Responses In Advance
>


From: Parker on 29 Aug 2005 08:04
Thank You Both, I will look for these suggestions!


"Beth Melton" <bmelton(a)NoSpam4Memvps.org> wrote in message
news:%23PTRSrxqFHA.3436(a)TK2MSFTNGP15.phx.gbl...
> If you record a macro in Excel there is an option to store in "Personal
> macro workbook". If this is selected the Personal.xls is created and
> placed in the XLStart folder. Typically this workbook opens as a hidden
> window and you never see it. However if it was unhidden and saved then
> when Excel starts you will see the workbook.
>
> Either hide the workbook by going to Window/Hide or remove it from the
> XLStart folder. Note the XLStart folder that is used could be found in the
> user profile (Documents and Settings), rather than in the Office
> installation path.
>
> Please post all follow-up questions to the newsgroup. Requests for
> assistance by email can not be acknowledged.
>
> ~~~~~~~~~~~~~~~
> Beth Melton
> Microsoft Office MVP
>
> Word FAQ: http://mvps.org/word
> TechTrax eZine: http://mousetrax.com/techtrax/
> MVP FAQ site: http://mvps.org/
>
>
> "Parker" <nospam(a)nospam.com> wrote in message
> news:e%23uJ6GkqFHA.1444(a)TK2MSFTNGP10.phx.gbl...
>> Hello All,
>>
>> I have a client that when opening Excel from the shortcut on the desktop
>> it opens a "personal" file(named at the top next to Excel in the Program
>> title) that she didn't create, that can contain multiple macros?!?. If
>> they click on file then new the new workbook will then open fine. There
>> is nothing in the xlstart folder. Using Office 2000 Pro on Xp Pro. Any
>> Idea how this happened and how to stop it from opening this way?
>>
>> Thank You for Any Responses In Advance
>>
>
>


From: Parker on 29 Aug 2005 16:29
Hiding the Workbook did the trick, but I still was not able to find this
personal folder. I did a search to no avail on all drives. The Client is
happy so I thank you all again.


"Parker" <nospam(a)nospam.com> wrote in message
news:eLeP0GJrFHA.1032(a)TK2MSFTNGP12.phx.gbl...
> Thank You Both, I will look for these suggestions!
>
>
> "Beth Melton" <bmelton(a)NoSpam4Memvps.org> wrote in message
> news:%23PTRSrxqFHA.3436(a)TK2MSFTNGP15.phx.gbl...
>> If you record a macro in Excel there is an option to store in "Personal
>> macro workbook". If this is selected the Personal.xls is created and
>> placed in the XLStart folder. Typically this workbook opens as a hidden
>> window and you never see it. However if it was unhidden and saved then
>> when Excel starts you will see the workbook.
>>
>> Either hide the workbook by going to Window/Hide or remove it from the
>> XLStart folder. Note the XLStart folder that is used could be found in
>> the user profile (Documents and Settings), rather than in the Office
>> installation path.
>>
>> Please post all follow-up questions to the newsgroup. Requests for
>> assistance by email can not be acknowledged.
>>
>> ~~~~~~~~~~~~~~~
>> Beth Melton
>> Microsoft Office MVP
>>
>> Word FAQ: http://mvps.org/word
>> TechTrax eZine: http://mousetrax.com/techtrax/
>> MVP FAQ site: http://mvps.org/
>>
>>
>> "Parker" <nospam(a)nospam.com> wrote in message
>> news:e%23uJ6GkqFHA.1444(a)TK2MSFTNGP10.phx.gbl...
>>> Hello All,
>>>
>>> I have a client that when opening Excel from the shortcut on the desktop
>>> it opens a "personal" file(named at the top next to Excel in the Program
>>> title) that she didn't create, that can contain multiple macros?!?. If
>>> they click on file then new the new workbook will then open fine. There
>>> is nothing in the xlstart folder. Using Office 2000 Pro on Xp Pro. Any
>>> Idea how this happened and how to stop it from opening this way?
>>>
>>> Thank You for Any Responses In Advance
>>>
>>
>>
>
>


 |  Next  |  Last
Pages: 1 2
Prev: STDEDU.MSI not on my CD, needed for XP's sp-3 Update
Next: Error 1309 When Starting Office 2003 Program