Fullscreen Toggle Button

[Statto]

Hi, I'm trying to turn this lot of code into a toggle button so I can switch between fullscreen and non-fullscreen whilst having the power to decide what stays on or off. As you can see below, the code is executed on the click of a button. The problem is when the button is clicked again nothing happens. How can I solve this?

Please Login or Register  to view this content.

[LJMetzger]

Hi Statto,

To toggle full Screen try:

Please Login or Register  to view this content.

Do the same with the other items you want to toggle.

Lewis

[Statto]

Hi Statto,

To toggle full Screen try:

Please Login or Register  to view this content.

Do the same with the other items you want to toggle.

Lewis

Thanks. This code pretty much works, except for some reason the formula bar does not reappear after the button is clicked again to exit fullscreen.

Please Login or Register  to view this content.

[LJMetzger]

Hi,

You did everything correctly. The code showed the same problem on my computer (Excel 2003). Apparently there is a 'side effect' when trying to ENABLE the 'Formula Bar' display, when the Full Screen was previously ENABLED.

Try the following code, which seemed to work for me.

Lewis

Please Login or Register  to view this content.

[Statto]

Hi,

You did everything correctly. The code showed the same problem on my computer (Excel 2003). Apparently there is a 'side effect' when trying to ENABLE the 'Formula Bar' display, when the Full Screen was previously ENABLED.

Try the following code, which seemed to work for me.

Lewis

Please Login or Register  to view this content.

Thanks a lot. That works well.