+ Reply to Thread
Results 1 to 11 of 11

cant see drawing toolbar

  1. #1
    Registered User
    Join Date
    08-27-2003
    Location
    Perth, Australia
    MS-Off Ver
    2000
    Posts
    47

    cant see drawing toolbar

    Hi

    I've recently got a new computer and this problem is driving me nuts.
    When I click view!toolbars!drawing, nothing happens. No drawing toolbar appears at the bottom of the screen where it used to be. There's a small "drawing toolbar" icon on the main toolbar, but whether this is depressed or not makes no difference either.

    I understand this may be changed in the 2007 version, but I’m using Excel 2000

    It’s probably a really simple solution, but neither the help screens nor a quick google gave any solution.
    Nicky

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Try this, on the end of the Standard Toolbar is a drop down arrow (next to the ?) . Click, Add or Remove option > Standard > Rest Toolbar.

    Does that help?
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    08-27-2003
    Location
    Perth, Australia
    MS-Off Ver
    2000
    Posts
    47
    Hi
    Thanks for the tip - I tried it, but I'm afraid it didn't work

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    If you go to View > Toolbars has the Drawing Toolbar got a tick next to it?

  5. #5
    Registered User
    Join Date
    08-27-2003
    Location
    Perth, Australia
    MS-Off Ver
    2000
    Posts
    47
    yes - I've toggled this on an off using view!toolbars, by clicking the icon that's part of the standard toolbar, and with the 'reset toolbar' command on the down arrow at the end of the standard toobar as you suggested. None of this seems to work, even with the drawing toolbar ticked.

  6. #6
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    OK, let try something else. Go to Tools > Customise > Options, Rest menu and toolbar usage data.

    Also have you got the active window on max?

  7. #7
    Registered User
    Join Date
    08-27-2003
    Location
    Perth, Australia
    MS-Off Ver
    2000
    Posts
    47
    Sorry tried that:
    Tools > Customise > Options

    while I was at it I also tried
    Tools > Customise > toolbars > reset
    which didn't work either

  8. #8
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Have a look at this link, there may be a few options you haven't tried yet?

    http://www.mvps.org/dmcritchie/excel/toolbars.htm

    Let me know how you get on?

  9. #9
    Registered User
    Join Date
    08-27-2003
    Location
    Perth, Australia
    MS-Off Ver
    2000
    Posts
    47
    Thank you very much for your help
    Its nearly 6pm here in Western Australia and I'm off to a lecture now, but will check out the site in the morning when I return to work, and let you know how I go in a few hours.
    Thanks again

  10. #10
    Registered User
    Join Date
    08-27-2003
    Location
    Perth, Australia
    MS-Off Ver
    2000
    Posts
    47

    Smile

    Hi

    The website gave me the clue to how to solve it.

    With Excel closed, I found my Excel.xlb file and moved it to another directory (just in case ...). Then I open Excel, reset the toolbars as I like (including Drawing, which appeared properly when selected), then closed Excel, which automatically created a new Excel.xlb file that now loads my settings as a I like whenever I open Excel.

    I guess I'd done something to my stored toolbar settings in Excel.xlb that I coudn't work out how to reverse, but starting from scratch is very easy, so this worked fine.

    Thanks again for your help

  11. #11
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Great, glad to hear you resolved it - thanks for the feedback

+ 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