Link to home
Start Free TrialLog in
Avatar of inewman
inewman

asked on

How to make windows taskbar autohide from Excel VBA code

With my worksheets in full screen mode the bottom scroll bar is hidden by the Windows Task Bar.  Is there any way to put the Task Bar in autohide mode from VBA code and then restore it when the worksheet is closed.  Thanks.

Ira
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Hi Ira,

According to http://support.microsoft.com/default.aspx?scid=kb;en-us;179363
there is no way to programmatically autohide the task bar, but there is a workaround--
expand the size of the current window to cover the whole screen.

Might you not be better just enabling auto hide the old-fashioned way? :)

Regards,

Patrick
ASKER CERTIFIED SOLUTION
Avatar of Jeroen Rosink
Jeroen Rosink
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of inewman
inewman

ASKER

Jeroen

Checked a lot of references that said that this was impossible. Thanks.

Ira
perhaps those references are talking about autohiding the taskbar. this piece of code is hiding it completly.

Thanks for the grade!
Jeroen