Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I found this code on another post and it works perfectly... however (see below)
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 However, This seems to be setting a visible flag for the task bar. What I need is to activate/deactivate the minimize of the task bar. (When you position the mouse on the top line of the task bar, you get a double-headed arrow. when you click-drag down, it minimizes the task bar. This leaves a small line which is the top of the task bar that you can grab and drag up to un-minimize the task bar). How do I access that feature from VBA (using API or not) I need this so that when I set my spreadsheet to show fullscreen, the status bar gets hidden under the taskbar (becuse I want to leave it set "always on top") I have found that manually minimizing then maximizing the taskbar forces the status bar to show (I.E. the spreadsheet's full screen becomes limited at the bottom to force both the taskbar and the (excel) statusbar to be both visible.) Also Im curious what the & in the above "FindWindowEx&" API call code does. The code stops working when that character is removed. -- Regards, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
i want all windows in one excel frame (windows in taskbar) | Excel Discussion (Misc queries) | |||
Windows Taskbar | Setting up and Configuration of Excel | |||
Windows in taskbar | Excel Discussion (Misc queries) | |||
windows in taskbar | Setting up and Configuration of Excel | |||
Controlling the windows taskbar from VBA? | Excel Programming |