Preventing Taskbar from Blocking Bottom Of Excel Workbook On Fullscreen

I am using a macro to hide all of the Excel toolbars and menu bars upon opening a workbook. Excel also opens in full screen view. The problem is that the lower portion of the workbook is cut off and not shown because the windows taskbar is in front of it. Is there anyway around this. I know I can autohide the taskbar but this workbook will be used by many users on different computers and I dont want to inconvenient them by having to change their taskbar preferences.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello bbarrene,

Do you want the contents visible on the screen without scrolling or why is the taskbar an issue?

You could use a maximised window instead of Full screen view and then change the zoom factor, so the spreadsheet fits on one page.

But with different users on different monitors, you'll never really know how it will look.

I have my task bar to the left of the screen and if I use Full screen view, the taskbar it disappears and becomes inaccessible until I close the Full screen view.

So maybe you won't be able to anticipate all issues with Full screen. But with a maximised window, you at least know how it should behave.

cheers, teylyn

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.