Page 1 of 2 12 LastLast
Results 1 to 15 of 25
  1. #1
    Azri1
    Guest

    can excel97 display like web browser...

    what i meant is like using frame where the menu is at
    the left corner and the sheet that we select will appear
    in the right corner.is it possible or i'm just dreaming.lol.
    thanks

  2. #2
    Star Lounger
    Join Date
    Dec 2000
    Location
    Sydney, New South Wales, Australia
    Posts
    64
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: can excel97 display like web browser...

    I'm not sure if this is what you mean .... but .... you can move the menu bars to the left side of the screen by clicking on a vacant section of the menu, holding the left mouse button down and then dragging the menu to the left.

    The menu bar will then lock itself to the left side of the screen in a vertical direction .. a bit like a web page menu.

  3. #3
    Azri1
    Guest

    Re: can excel97 display like web browser...

    maybe thats the solution..could u show me how to do that..
    please.thanks

  4. #4
    Star Lounger
    Join Date
    Dec 2000
    Location
    Sydney, New South Wales, Australia
    Posts
    64
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: can excel97 display like web browser...

    On the left end of the button bar there will be 2 upright gray lines. Move the mouse so that the cursor is on these lines.

    Then hold the left mouse button down.

    Then drag the button bar down and to the left while still holding the left mouse button down.

    The menu bar will then lock itself to the left side of the screen in a vertical direction.

    Let me know how you go.

  5. #5
    Azri1
    Guest

    Re: can excel97 display like web browser...

    sorry.i'm a slow learner.could u elaborate it more details
    and slow.what kind of button bar do u mean.where is it located ..i cant find it plz help me..thanks

  6. #6
    Azri1
    Guest

    Re: can excel97 display like web browser...

    i have think.n find 1 solution..could u sppare your time
    and mail me an example workbook on how to do this..i think it''s more practical..coz i don't have any clue how to do this.plz and thanks again.my email is : boymoii@hotmail.com
    thanks for the response

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: can excel97 display like web browser...

    If I interpret what you want correctly, what is required is a method of selecting worksheets by way of a menu on the left side of the screen, instead of the usual method of using the sheet tabs.

    I am attaching a workbook to show what I mean. I used two windows on the same workbook, one on the left with clickable navigation buttons. The window on the right is just a normal view on the selected worksheet. What the best implementation of your requirements is would depend on the nature of the sheet you are working with. The attached is just to give you an idea.

    Andrew C
    Attached Files Attached Files

  8. #8
    Azri1
    Guest

    Re: can excel97 display like web browser...

    thanks guys for the response..but thats not what i have in my mind..please refer to my attachment or go to this url..
    so u can understand what i meant..many thanks.hope u guys can help me..

  9. #9
    Azri1
    Guest

    Re: can excel97 display like web browser...

    i think u stilll not u/stand what i'm trying to do..
    what i meant is..let say i have 10 macros represent
    by 10 command buttons..i want it to be displayed by frames.
    if u surfing to webpages..u will understand what i meant
    by frames..user will click the command buttons on the left,
    and the pages that they required will appereared in the right corner while the command buttons will stay at the left
    corner..they will always can see the command buttons..the pages that the user desired will always displayed in the right corners..thanks..hope u can u/stand my questions and will help me..regards

  10. #10
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: can excel97 display like web browser...

    You mean like the attached?
    (Print buttons don't work)

    Later - attachment deleted

  11. #11
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: can excel97 display like web browser...

    I think John may have gone off line. (This has been done with Excle 2K but should apply)

    1] Move the cursor to the left hand end of the toolbar you want to move - it turns into a 4 pointed cursor.

    2] Left click and hold and drag the toolbar away from its current position.

    3] Move it towards the left side and it will switch to a vertical layout and 'dock' into position.

    Is that what you are trying to achieve ?

    Later - attachment deleted

  12. #12
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: can excel97 display like web browser...

    The only thing I can come up with is to create a custom toolbar, move it to the left margin and assign the macros to it:

    Right mouse on toolbar - customize.
    Select Toolbars/New (Call it what you like)
    Commands: Under Categories select Macros, drag Custom button onto new toolbar
    Repeat until you have enough buttons.
    Close

    Button #1
    Add the following as a macro to the sheet:
    Sub Sel2()
    Worksheets(2).Select
    End Sub

    Right mouse on toolbars again - Customise
    Right mouse on first macro button on your new toolbar
    Name: Change to 'Sheet 2' and select 'Text Only (always)
    Assign macro: select Sel2

    etc.

    Unfortunately, all text in the toolbar buttons is vertical...
    Attached Images Attached Images
    • File Type: png x.png (1.8 KB, 0 views)

  13. #13
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: can excel97 display like web browser...

    I am attaching an amended version of the previous file I uploaded as I think it may not have displayed as I intended. I think you will find it does much of what you want (at least what I think you want).

    Andrew C
    Attached Files Attached Files

  14. #14
    Azri1
    Guest

    Re: can excel97 display like web browser...

    thanks andrew and all..your file is the most close like
    i want..but the problem is when i click the sheet that
    i desired..the frame will dissapear..could u modify it
    so when we click the button..the menu at the left side will remain and can be seen all the time..is it possible..thanks

    ps : so the display will look like 2 parts..part 1 is menu at the left side..while part 2 is the page that we select at the right side..thanks

  15. #15
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: can excel97 display like web browser...

    Works OK here.
    Are you downloading it and running it, or running from your browser?

Page 1 of 2 12 LastLast

Posting Permissions

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