Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 49
Default Temporary file open; not visible at all

Is there a way to hide a workbook, so it is not visible in the taskbar of
Windows?

Gert-Jan



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 49
Default Temporary file open; not visible at all

Found it: Application.ShowWindowsInTaskbar = False


"Gert-Jan" schreef in bericht
...
Is there a way to hide a workbook, so it is not visible in the taskbar of
Windows?

Gert-Jan





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Temporary file open; not visible at all

That should make only one item (generic excel) appear in the taskbar - not
exactly what you asked.

--
Regards,
Tom Ogilvy


"Gert-Jan" wrote:

Found it: Application.ShowWindowsInTaskbar = False


"Gert-Jan" schreef in bericht
...
Is there a way to hide a workbook, so it is not visible in the taskbar of
Windows?

Gert-Jan






  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Temporary file open; not visible at all

If I go to window=hide and hide the workbook, it does not appear in the
taskbar. Turn on the macro recorder while you do it manually. I can't
imagine what method you are using that doesn't do this.

--
Regards,
Tom Ogilvy



"Gert-Jan" wrote:

Is there a way to hide a workbook, so it is not visible in the taskbar of
Windows?

Gert-Jan




  #5   Report Post  
Posted to microsoft.public.excel.programming
JK JK is offline
external usenet poster
 
Posts: 9
Default Temporary file open; not visible at all

You can use:

Application.Visible = False

JK

Gert-Jan wrote:
Is there a way to hide a workbook, so it is not visible in the taskbar of
Windows?

Gert-Jan




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I open temporary internet files mdoyer Excel Discussion (Misc queries) 3 October 12th 09 07:41 AM
CREATE TEMPORARY FILE WHEN SAVE Bhavin Excel Discussion (Misc queries) 0 October 2nd 09 02:01 PM
Temporary File Error with SendMail NicB.[_3_] Excel Programming 1 May 12th 06 07:39 PM
want VB6 to edits Excel in background and not become visible when I open another excel file Zee[_3_] Excel Programming 6 November 18th 05 10:46 PM
no worksheets are visible when I open a file by a right click njvbguy Excel Programming 1 September 19th 05 05:29 AM


All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"