Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 macro
How can I prevent the workbook that stores my macros from opening each time I
open a workbook? When I open a saved workbook I have to click the windows icon or reduce the workbook that contains my macros before the workbook I want opened come up. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 macro
Are you talking about your personal.xls(b)
Do you see this file? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "wcurtis" wrote in message ... How can I prevent the workbook that stores my macros from opening each time I open a workbook? When I open a saved workbook I have to click the windows icon or reduce the workbook that contains my macros before the workbook I want opened come up. Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 macro
yes
"Ron de Bruin" wrote: Are you talking about your personal.xls(b) Do you see this file? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "wcurtis" wrote in message ... How can I prevent the workbook that stores my macros from opening each time I open a workbook? When I open a saved workbook I have to click the windows icon or reduce the workbook that contains my macros before the workbook I want opened come up. Thanks in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 macro
Hide the macro workbook(probably Personal.xlsx) under ViewHide
Close Excel and you will asked if you want to save changes. Click "Yes" Now it will open hidden when you start Excel. Gord Dibben MS Excel MVP On Tue, 12 May 2009 08:15:00 -0700, wcurtis wrote: How can I prevent the workbook that stores my macros from opening each time I open a workbook? When I open a saved workbook I have to click the windows icon or reduce the workbook that contains my macros before the workbook I want opened come up. Thanks in advance. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 macro
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: WindowHide 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 "wcurtis" wrote in message ... yes "Ron de Bruin" wrote: Are you talking about your personal.xls(b) Do you see this file? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "wcurtis" wrote in message ... How can I prevent the workbook that stores my macros from opening each time I open a workbook? When I open a saved workbook I have to click the windows icon or reduce the workbook that contains my macros before the workbook I want opened come up. Thanks in advance. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 macro
Make that Personal.xlsb
Gord On Tue, 12 May 2009 08:47:52 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Hide the macro workbook(probably Personal.xlsx) under ViewHide Close Excel and you will asked if you want to save changes. Click "Yes" Now it will open hidden when you start Excel. Gord Dibben MS Excel MVP On Tue, 12 May 2009 08:15:00 -0700, wcurtis wrote: How can I prevent the workbook that stores my macros from opening each time I open a workbook? When I open a saved workbook I have to click the windows icon or reduce the workbook that contains my macros before the workbook I want opened come up. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pick up a value in MOSS 2007 with a macro inExcel 2007 | Excel Discussion (Misc queries) | |||
Macro not working in 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions |