Thread: 2007 macro
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.