Hey'all
This forum has come very handy to me, but now I've found a code that doesn't work for me.
I'm looking for a macro that can toggle the task bar from showing. With the purpose I can run the excel program in full-screen.
code i found on this forum:
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
I have windows 7 and excel 2007. For me, this code make's the task bar invisible, but the start button is still visible. and i can't run excel full screen because the space of the task bar is still token.
(I added a print screen for you to see how the macro works for me)
Can anybody help me with this?
Thanks in advance
Bookmarks