ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Temporary file open; not visible at all (https://www.excelbanter.com/excel-programming/366340-temporary-file-open%3B-not-visible-all.html)

Gert-Jan

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




Gert-Jan

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






Tom Ogilvy

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





Tom Ogilvy

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







JK

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




All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com