Shoutbox

quote:

---

Originally posted by Adeptus
Although some of he lines in your picture appear to be drawn in (the overlapping double border of the top area) and I don't think you will be able to make it look exactly like that, the rest seems just cell background color and borders.  Right click, Format Cells -- or am I missing something about your question?

---

i tried that but the cell formatting doesnt match the boxes, so it overlaps and stuff, looks really dodgy..

i've changed thing around a bit to use cell formatting but it didn't end up like i wanted. oh well!

Whats wrong with this? it says compile error... i've tried tons of things it makes no sense!!!!

quote:

---

Sub Start()
'
' auto_open Macro
    With ActiveWindow
    Application.Caption = "PB Insurance Services Ltd"
        .DisplayGridlines = False
        .DisplayHeadings = False
        .DisplayHorizontalScrollBar = False
        .DisplayVerticalScrollBar = False
        .DisplayWorkbookTabs = False
    End With
    With Application
        .DisplayFormulaBar = False
        .DisplayStatusBar = False
    End With
      Application.CommandBars("standard").Visible = False
      Application.CommandBars("formatting").Visible = False
    Sub auto_open()
    Load UserForm1
    UserForm1.Show
End Sub

---

thanks for any help!

EDIT: needed an extra end sub, DUH >.<