Thread: Hide Workbook
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default 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.