+ Reply to Thread
Results 1 to 3 of 3

Format cell window size

Hybrid View

  1. #1
    KHall1968
    Guest

    Format cell window size

    when you right click on a cell, it brings up a window. This window has tabs
    on it, I can not see all the tabs and can not figure out how to change the
    windo size to see all the tabs. Help

  2. #2
    Richard Buttrey
    Guest

    Re: Format cell window size

    On Wed, 12 Oct 2005 11:54:02 -0700, KHall1968
    <KHall1968@discussions.microsoft.com> wrote:

    >when you right click on a cell, it brings up a window. This window has tabs
    >on it, I can not see all the tabs and can not figure out how to change the
    >windo size to see all the tabs. Help



    Right clicking on a cell simply brings up a menu of the sorts of
    things you can do with that cell. i.e. Copy, Format, Delete etc..

    When you say it brings up a window, are you saying that there's
    perhaps a VBA macro which runs as a result of a right click event on
    any cell in the sheet and which opens up a Form window?

    If so it may be that the form has not been made wide or tall enough.
    If so, simply

    1. Open the VB Environment with ALT - F11
    2. Make sure the VBA Project Window is showing, if not click the View
    Menu and select "Project Explorer.
    3. Expand the "+" symbol on the Workbook name in question
    4. Find the "Forms" object and expand the "+" symbol
    5. Select the Form that's giving you a problem and drag the handles to
    enlarge it as appropriate.
    6. Close the VB Environment by clicking the usual "x" in the corner.

    HTH

    __
    Richard Buttrey
    Grappenhall, Cheshire, UK
    __________________________

  3. #3
    KHall1968
    Guest

    RE: Format cell window size

    Thank you so much. I now have it the size I need.

    "KHall1968" wrote:

    > when you right click on a cell, it brings up a window. This window has tabs
    > on it, I can not see all the tabs and can not figure out how to change the
    > windo size to see all the tabs. Help


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1