ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is it possible to hide the Windows Task Bar? (https://www.excelbanter.com/excel-programming/320079-possible-hide-windows-task-bar.html)

quartz[_2_]

Is it possible to hide the Windows Task Bar?
 
I am using VBA in Excel XP with Windows 2000.

Is it possible to hide the Windows Task Bar using VBA (perhaps with an API)?
If so, could someone please post a function that can be used to hide/unhide
it?

Thanks much in advance.

Michel Pierron

Is it possible to hide the Windows Task Bar?
 
Hi quartz,

Private Declare Function FindWindowEx& Lib "user32" Alias "FindWindowExA" _
(ByVal hWnd1&, ByVal hWnd2&, ByVal lpsz1$, ByVal lpsz2$)
Private Declare Function ShowWindow& Lib "user32" (ByVal hwnd&, ByVal
nCmdShow&)

Sub TaskBar_Hide()
ShowWindow FindWindowEx(0, 0, "Shell_TrayWnd", vbNullString), 0
End Sub

Sub TaskBar_Show()
ShowWindow FindWindowEx(0, 0, "Shell_TrayWnd", vbNullString), 5
End Sub

MP


"quartz" a écrit dans le message de
...
I am using VBA in Excel XP with Windows 2000.

Is it possible to hide the Windows Task Bar using VBA (perhaps with an

API)?
If so, could someone please post a function that can be used to

hide/unhide
it?

Thanks much in advance.



quartz[_2_]

Is it possible to hide the Windows Task Bar?
 
Just what I needed, thanks a lot!

"Michel Pierron" wrote:

Hi quartz,

Private Declare Function FindWindowEx& Lib "user32" Alias "FindWindowExA" _
(ByVal hWnd1&, ByVal hWnd2&, ByVal lpsz1$, ByVal lpsz2$)
Private Declare Function ShowWindow& Lib "user32" (ByVal hwnd&, ByVal
nCmdShow&)

Sub TaskBar_Hide()
ShowWindow FindWindowEx(0, 0, "Shell_TrayWnd", vbNullString), 0
End Sub

Sub TaskBar_Show()
ShowWindow FindWindowEx(0, 0, "Shell_TrayWnd", vbNullString), 5
End Sub

MP


"quartz" a écrit dans le message de
...
I am using VBA in Excel XP with Windows 2000.

Is it possible to hide the Windows Task Bar using VBA (perhaps with an

API)?
If so, could someone please post a function that can be used to

hide/unhide
it?

Thanks much in advance.





All times are GMT +1. The time now is 04:08 PM.

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