Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Remove a Personal xls
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? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Remove a Personal xls
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 WindowHide... 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 HIS www.nickhodge.co.uk "jk" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Remove a Personal xls
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? "Nick Hodge (MVP)" wrote: 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 WindowHide... 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 HIS www.nickhodge.co.uk "jk" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
Remove a Personal xls
With Personal.xls open, go to WindowHide 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 On Sun, 23 Jul 2006 19:49:01 -0700, jk wrote: 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? |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
Remove a Personal xls
Thanks a million...that did the trick...excel opens with the standard three
sheets! Regards "Gord Dibben" wrote: With Personal.xls open, go to WindowHide 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 On Sun, 23 Jul 2006 19:49:01 -0700, jk wrote: 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? |
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
Remove a Personal xls
Happy to help.
Thanks for letting us know what worked for you. Gord On Mon, 24 Jul 2006 17:26:01 -0700, jk wrote: Thanks a million...that did the trick...excel opens with the standard three sheets! Regards "Gord Dibben" wrote: With Personal.xls open, go to WindowHide 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 On Sun, 23 Jul 2006 19:49:01 -0700, jk wrote: 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? Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i remove the several hyperlink option after entering the . | Excel Discussion (Misc queries) | |||
How can i remove the several hyperlink option after entering the . | Excel Discussion (Misc queries) | |||
remove characters from a text under a condition | Excel Discussion (Misc queries) | |||
Personal macro file will not pull up when excel is started | Setting up and Configuration of Excel | |||
Illinois Personal Information Protection Act | Excel Worksheet Functions |