Open then minimize workbook

[mnmhenry]

I have tried searching for this code but just cant find (or remember) how i did it before.

I have a regular workbook (which changes name upon start up). In this workbook is a button that opens a linked database of products.

I want this button

1. to open the database C:/Database/db.xls
2. Minimize it
3. Maximize my regular workbook to its original state (this is where I am having the problem because the workbook name constantly changes)

Thanks for helping
Mark

 

[jbeaucaire]

Maybe like this:

Application.ScreenUpdating = False
    FilePath = "C:/Database/db.xls"
    Workbooks.Open FilePath
    ActiveWindow.Visible = False
Application.ScreenUpdating = True

 

[jbeaucaire]

The benefit of the one above is that the sheet is completely hidden. If that's not what you want, just want it minimized, this will do that:

Application.ScreenUpdating = False
    Workbooks.Open "C:/Database/db.xls"
    ActiveWindow.WindowState = xlMinimized
Application.ScreenUpdating = True

 

[mnmhenry]

super, works a treat. Thanks very much

 

[#BoB#]

ADVERTISEMENT

Hi,

I had a similar requirement as in this thread. I tried the code (ActiveWindow.Visible = False)

And now my workbook doesn't show at all, even if I disable macros. Please tell me how to make my workbook visible


Regards,

 

[#BoB#]

Hi,

Can anyone tell me how to make my workbook visible again.

I tried

ActiveWindow.Visible = true

But my workbook still doesn't show up

 

[jbeaucaire]

ADVERTISEMENT

It's not active anymore, so you'll have to call the workbook by name instead of "ActiveWorkbook".

 

[Arcticwarrio]

Click on window in the Toolbar and then on Unhide?

 

[#BoB#]

Hey,

Got it

The unhide option was in windows menu.