2007 macro

  • Thread starter Thread starter wcurtis
  • Start date Start date
W

wcurtis

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.
 
Hide the macro workbook(probably Personal.xlsx) under View>Hide

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
 
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: Window>Hide
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
 
Make that Personal.xlsb


Gord

Hide the macro workbook(probably Personal.xlsx) under View>Hide

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
Click to expand...
 
Back
Top