Question: How do I hide the Title Bar?

Hot Topic

implemnting cache in best possible way
troubleshooting saving versions with macro in Word
Is Partner program open for non-consulting/non-ISV companies?
whats wrong with this code?
Error Handling Code
Bloomberg + Execel = True?
Projects, objects & modules
SendKeys open application
OUTLOOK When trying to open Outlook, I get the following:
Using VBA macro to locate next free column on worksheet

Microsoft ISV

Excel disjunction
AutoExec will not execute properly
Can't open regedit
Export excel sheet as text file with macro code
What is the code for closing out an excel file while in the browser?
Once copied, can we export as a GIF file?
Using Proper function to Format Worksheet
DLookup help?
last Modified date in Excel spreadsheet
Unable to infopath form in browser

Question: How do I hide the Title Bar?

Howdy...

I'm writing a program in Excel and I was wondering how to hide the Title Bar. The one with "Microsoft Excel" and the min., restore, and close button.

If that's not possible, is it possible to deactivate the close button





Answer this question

Question: How do I hide the Title Bar?

  • Luis D. Rojas

    I'm not working with Forms....I want to hide the application title bar.


  • parveenpanjla

    Hi,

    Have a look at Stephen Bullen's FunForm workbook.
    http://www.oaltd.co.uk/Excel/Default.htm

    I know his code is designed to apply the formatting to a userform. But by changing the code in the class to use the application window handle rather than the userform the effects still work.

    But be very careful when playing around with application setting. Make sure your code returns the enviroment to the same state you found it in. Nothing worse than using somebodys code only to find it leaves excel in an unusable and re-arrange state.


  • StephenMas

    Set the forms borderstyle property to none.
  • Question: How do I hide the Title Bar?
Answer this question