Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Special Window Mode

  1. #11
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-11 14:24, Jack in the UK wrote:
    Mark

    if directed at me.. hey cool man.. no bother
    Nah, not directed at you Jack. Or should I say "Steve"? (I've been PM ing Chris D and he flatly refuses to tell me your "real name"). I know you used to use it before getting stick from people on the old board, so I was trawling that to find out if I could unmask you. No success though.

  2. #12
    New Member
    Join Date
    Feb 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-11 14:15, Mark O'Brien wrote:
    Yeah, the menu bar that's why I said "most" in my original post.

    That one you would have to get rid of using VBA, I think.

    You could use this code:


    Private Sub Workbook_Open()
    If Application.CommandBars("Worksheet Menu Bar").Enabled = True Then
    Application.CommandBars("Worksheet Menu Bar").Enabled = False
    End If
    End Sub


    You would put this code in the Workbook object. To do this:

    1. Right Click on the XL icon next to "File"
    2. Select "View Code"
    3. Copy and paste the above code into the window that comes up.

    Note: When you save this book and reopen it, you're going to get a macro warning that asks if you'd like to enable or disable macros.

    I'm going to pre-empt you now. If you want to know how to get rid of this warning, I'll hunt you down and give you a noogie. (Seriously, do a search on this site for the macro warning question, it's a touchy subject around here).

    HTH

    Nice one!

  3. #13
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey easy... no one will know ever one knows me as this sign in, i got fed up of being abused and sworn at as i can spell and read very well, i have often said i have dread full schooling and so am a product on the hadrd knocks. but i stay as i am, i have used a few names.. thus why i kicked up over annonomouse posts jsut a tag so we can be friendly tahts all i do care so much if nick name..

    No you are plas with Chris D and so am i Chris will never tell he has given me his word and thats good enough for me, if it came out i would disapear, as i would get abused again, i have had this hear a few times already.. so you they them are cleaver tyhan me i care not wanna see my emails and priviate ness i get all positave.. so i care not now

    I ask littel and give as i can.. Jack is the name of one of my heros, my son take his name other heros name.. he was a friend and a gangster so no im not telling who..


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #14
    New Member
    Join Date
    Feb 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Jack or whoever, youre a good guy and should never have to put up with abuse from muppets!. You give good advice and always try to help. What's their problem? You are spending you time helping folks so ignore them and feel superior!

  5. #15
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Andy Gee

    a deep thank you personally to you.

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •