Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Special Window Mode

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

    Default

    Is there any way I can force a spreadsheet to open in a window without menus, buttons, status bar, row and column headings etc.?

    Any help will be greatly appreciated!

  2. #2
    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

    You'd have to do it through VBA, unless you want to permanently remove most of those thing. If you're looking to permanently do that then goto Tools|Options and then find the appropriate check boxes to uncheck.

    An easy way to make some VBA code for this is to goto Tools|Macros|Record New Macro and then go to Options to get rid of that stuff.

    HTH

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

    Default

    Of course! Thanks

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

    Default

    Great, But how do I remove the menu bar?

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

    Default

    HI

    ! un select any of the stuff you do not want ie standard barm formatting bar,

    Tool options gives thinks like scroll bars and so on.

    Can be automated via scripts, but my call is when you close that wkbk replace what ever you removed so they are there for other books else you have to re set it all each time.

    also caution this will stop other wkbs that are also open from viewing these things ie scroll bar and so on, untill vba is cancelled ie reversed, no selection can be made if the code is correct.... just though that was important point.


    Free Excel based Web Toolbar available here.

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

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

    Default

    Thanks, very valid points, I added a beforeclose macro to bring the standard things back. But I can't remove the menu, any ideas?

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

    Default

    sorry for the wolrds stuidest question but what menu mide dead, i do not have excel loaded as im testing Windows XP with IE and net access, horible nasty horrid thing yuck!

    so i cant see for myself


    Free Excel based Web Toolbar available here.

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

  8. #8
    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

    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


  9. #9
    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

    I just read one of your posts. Sorry if some of my last answer sounds condescending, you're obviously familiar with VBA. A lot of people that post here aren't. Better safe than sorry though.

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

    Default

    Mark

    if directed at me.. hey cool man.. no bother
    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
  •