Revert to Windows Classic Style for Excel Macro or XP Title Bar Size

[senators40]

Hi,

I have a macro with userforms that were configured in the Windows Classic Style.

In that style the information contained on those userforms can be seen, however in XP with the height of the title bar and the Start Bar some of the information is missing / hidden.

Is there any way to program within the macro to revert to the Windows Classic Style or alternatively reduce the size of the title bar in XP.

Once they stop the program I would like to revert back to XP.

Please let me know

Thanks in Advance

Jeff

 

[TonyJollans]

Make your form a bit smaller! It's only a few pixels.

I'm sure it's possible to switch to classic style - but it is a windows-wide setting and will affect all applications. i also suspect you may have great difficulty extracting the user preferences and resetting them all when you're done. If your userforms really take all the screen without any slack they really are too full and could do with a redesign.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association