[SOLVED] VBA Code to set Windows Taskbar auto hide to OFF

[claudiocustodio]

Hello Excel Professionals, this is my first post here.

I found on the internet a VBA code that allows me to set the taskbar Auto Hide on. It works like a charm, perfect. The problem is that to set it back to OFF it does not work. I mean I need the taskbar autohide to set to OFF when I call the Sub UnhideTaskbar below. But it does not work at all. There are some other codes on the net that only hides the taskbar, but It doesn't work because it won't allow full screen to fill it'a place on the screen. So I must use the Auto Hide property.

Again, The Goal is to Set taskbar AutoHide OFF. How can I do it?

Thanks !

CODE:

Please Login or Register  to view this content.

[claudiocustodio]

I forgot to mention that I am using Excel Office 365.

Thanks.

[Artik]

For me, both procedures work without any problems (Win 10, MSO 365 32-bit).

Artik

[claudiocustodio]

Interesting Artik that UnhideTaskbar Sub is working for you. I have tested it in two computers won't run on both. In fact the UnhideTaskbar Sub works as the HideTaskbar Sub, they both set the Auto hide to ON. Very strange my friend.

[claudiocustodio]

Thats what I forgot to mention, My Windows version is 10 PRO , and in fact the UnhideTaskbar Sub works as the HideTaskbar Sub, they both set the Auto hide to ON on both computers. Very strange.

[Artik]

What bit version of Office are you using? 32 or 64-bit?

Artik

[claudiocustodio]

Thanks Artik for the question. Office is 64 Bits. I know in my code I am calling shell32.dll.
What change should I make in my code?

[claudiocustodio]

Complementing, the Function works because I am already using the PtrSafe.
The problem is that UnhideTaskbar SUB also set the Auto Hide mode to ON. Not to OFF.

[claudiocustodio]

I am now sending my Excel sample file. Please check the attachment.
I have created two "buttons" and assigned each Sub to it.

[Artik]

I don't have a 64-bit version at the moment to check, but try to replace all code to

Please Login or Register  to view this content.

For you, the code between #Else and #End If will turn red. Do not worry about it. This fragment will not compile on your version.
The code should work on both bit versions.

Artik

[claudiocustodio]

Artik, you are a Genius, thank you so much.
You code is showing some error, I could not find were the error is, maybe is some whrong character.
But anyway, I saw that you changed the TYPE for hWnd to LongPtr.
So I just changed that in my Original code and it worked like a Charm. Thank you so much!!
IŽll also insert the code as you did to check the BIT Version.

Don't know what to do to thank you more.

[Artik]

Artik, you are a Genius

I'm not a genius. It's a couple of years of experience.

I saw that you changed the TYPE for hWnd to LongPtr.

This is not the only change. Note that the SHAppBarMessage function type has also changed, from Long to LongPtr

Thank you so much!!

You're welcome. I also benefited from this thread.

Artik

[claudiocustodio]

Ok Artik, Now if I change the SHAppBarMessage function type to LongPtr, the code won't work.
But no problem, the code is working now.

Thanks!

[Artik]

I would have been looking for the cause of the error for a long time if I had not run the code on the 64-bit version. I haven't noticed that abd_retval and abd_setval variables are incorrectly declared. Download the code from post # 10 again because I corrected it.
The fact that the code after your corrections worked should be treated as a coincidence. It probably wouldn't work under certain circumstances.

Artik

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[claudiocustodio]

Thanks Artik for the help, but still the new code does not work . As I am not too advanced in VBA I don't know why. And yes, the fact that by only changing hWnd to LongPtr made my code work I don't know why!!!

[Haluk]

On Excel 2010 64 Bit, the code given by Artik in message #10 works for me if the variable abd_retval is declared as "Variant" type.

Please Login or Register  to view this content.

[claudiocustodio]

Thanks Haluk and Artik. With Artik's code, but changing abd_retval to Variant works 100%.

I consider this Thread concluded.

Thanks all.