Hide Workbook
Try this from another workbook
Workbooks("WkbNameHere").window(1).hidden = True
or
Windows("WkbNameHere.xls").Visible = False
--
To get my email id paste my address in an Excel cell and press Enter...
"aftamath77" wrote:
I would like to write code that will hide a specific workbook when a userform
pops up. I tried:
Application.Visible = False
That works fine except, it hides Excel completely. I would like to hide
only the workbook that contains the userform.
|