Remove a Personal xls

[jk]

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?

 

[Nick Hodge \(MVP\)]

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[jk]

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?

 

[Gord Dibben]

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

 

[jk]

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

 

[Gord Dibben]

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!
Regards

Gord Dibben MS Excel MVP