| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open and hide a document by toggling
I use an Index file all the time. It is loaded but hidden whenever Excel is
on. When I click a button it comes on but I have to physically hide it when it is not wanted. How can the codes be changed so that the same button caries out both the tasks by toggling? Thank you if you can help. Susan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Open and hide a document by toggling
Try something like this:
If Not Windows("Book1").Visible Then Windows("Book1").Visible = True Else Windows("Book1").Visible = False End If HTH, Barb Reinhardt "susan" wrote: I use an Index file all the time. It is loaded but hidden whenever Excel is on. When I click a button it comes on but I have to physically hide it when it is not wanted. How can the codes be changed so that the same button caries out both the tasks by toggling? Thank you if you can help. Susan |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Open and hide a document by toggling
Marvellous, it works. Thanks Barb.
"Barb Reinhardt" wrote in message ... Try something like this: If Not Windows("Book1").Visible Then Windows("Book1").Visible = True Else Windows("Book1").Visible = False End If HTH, Barb Reinhardt "susan" wrote: I use an Index file all the time. It is loaded but hidden whenever Excel is on. When I click a button it comes on but I have to physically hide it when it is not wanted. How can the codes be changed so that the same button caries out both the tasks by toggling? Thank you if you can help. Susan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| toggling | Excel Worksheet Functions | |||
| How do I hide words on a printed document, but see on screen? | Excel Discussion (Misc queries) | |||
| my excel document won't open unless i go file, then open | Excel Discussion (Misc queries) | |||
| why must I open an Excel document twice to get it to open after . | Excel Discussion (Misc queries) | |||
| When I open excel document it always ask if I want to open it in . | Excel Discussion (Misc queries) | |||
Hybrid Mode
