Remove a Personal xls

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jk - 24 Jul 2006 03:49 GMT

I created a macro which unfortunately applied to all workbooks.Each time i
open a existing workbook, a personal xls open with it.I uninstalled office
and reinstalled but the same results appear.What can be done?

Reply to this Message

Nick Hodge (MVP) - 24 Jul 2006 07:44 GMT

You can delete personal.xls from your xlStart folder, but any code you want,
will be deleted with it, but you can also delete the macro from
personal.xls. To do this open the VBE (Alt+F11)

In here you should see on the left and entry for personal.xls. Under this
will be a folder called modules. If there is only one module in here, then
right click the folder and select remove and when asked if you want to
export it, answer no.

If there are more that you want to keep, just do this with the single
module.

Now close the VBE and if personal.xls is showing, go to Window>Hide... and
it will be hidden. Close Excel and if asked to save changes to personal.xls
say yes.

Now, correctly, Excel will still have a personal.xls which opens, but
hidden, each time and any code you want to apply to all books will still be
possible

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
www.nickhodge.co.uk

>I created a macro which unfortunately applied to all workbooks.Each time i
> open a existing workbook, a personal xls open with it.I uninstalled
> office
> and reinstalled but the same results appear.What can be done?

Reply to this Message

jk - 24 Jul 2006 10:41 GMT

Hi,
I removed all modules andnow when i click alt f11 i receive:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

in a window that says worksheet code.

There is only one one work sheet in this personal xls......so should this be
removed as well?

> You can delete personal.xls from your xlStart folder, but any code you want,
> will be deleted with it, but you can also delete the macro from
[quoted text clipped - 20 lines]
> > office
> > and reinstalled but the same results appear.What can be done?

Reply to this Message

Gord Dibben - 24 Jul 2006 20:46 GMT

With Personal.xls open, go to Window>Hide and select Personal.xls.

When you close Excel you will asked to save personal.xls.

Hit "yes".

Personal.xls will open hidden from now on with your macro(s) available for all
workbooks.

Gord Dibben MS Excel MVP

>I created a macro which unfortunately applied to all workbooks.Each time i
>open a existing workbook, a personal xls open with it.I uninstalled office
>and reinstalled but the same results appear.What can be done?

Reply to this Message

jk - 25 Jul 2006 01:26 GMT

Thanks a million...that did the trick...excel opens with the standard three
sheets!
Regards

> With Personal.xls open, go to Window>Hide and select Personal.xls.
>
[quoted text clipped - 10 lines]
> >open a existing workbook, a personal xls open with it.I uninstalled office
> >and reinstalled but the same results appear.What can be done?

Reply to this Message

Gord Dibben - 25 Jul 2006 03:30 GMT

Happy to help.

Thanks for letting us know what worked for you.

Gord

>Thanks a million...that did the trick...excel opens with the standard three
>sheets!
[quoted text clipped - 14 lines]
>> >open a existing workbook, a personal xls open with it.I uninstalled office
>> >and reinstalled but the same results appear.What can be done?

Gord Dibben MS Excel MVP

Reply to this Message