ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to hide workbook "title bar" (https://www.excelbanter.com/excel-discussion-misc-queries/134891-how-hide-workbook-title-bar.html)

Glauco

How to hide workbook "title bar"
 
I want to hide the workbook title bar (the blue one, with the workbook name,
the minimize, maximize and close buttons) after i run the macro below. How
can i do this? I just don't want to see that.

With ActiveWindow
.WindowState = xlNormal
.Top = 20
.Left = 1
.Height = 200
.Width = 300
End With

I'll have many windows in the screen, and i don't wanna see any title bar in
the screen. Thanks.


All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com