Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File|New view (XL97 on Win2000/NT4)

    In the File | New dialog there are three buttons to change the way the templates are displayed: large icons, small icons and details.

    Is there a way of making a particular view 'stick'. I'd rather have small icons as my default but can't persuade XL to see it my way so it's always large icons again when I come back to it.

    stuck

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: File|New view (XL97 on Win2000/NT4)

    Excel should save the view you select; it is stored in the registry (unfortunately in a binary value, HKEY_CURRENT_USERSoftwareMicrosoftOffice8.0CommonO pen
    FindMicrosoft ExcelSettingsOpenView). Could it be that your IT department has set a policy that restores this setting to a company-wide default each time?

  3. #3
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File|New view (XL97 on Win2000/NT4)

    XL saving the view I select is how I would expect it to behave. I very much doubt our IT people will have set such a policy but I will enquire.

    I have come across something on the Word MVP web site that persuades Word to display a particular view by replacing the built in File|New routine with some custom code, see http://www.mvps.org/word/FAQs/MacrosVBA/FileNewList.htm. Could this sort of thing be applied to XL97?

    stuck

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: File|New view (XL97 on Win2000/NT4)

    I may have been mistaken about the view sticking in the File | New... dialog (it should stick for the File | Open... dialog.)

    In Word, you can override a built-in command by creating a macro of the same name; unfortunately, that is not possible in Excel. But you can put a similar macro in your Personal.xls:

    Sub FileNew()
    SendKeys "%2"
    Application.Dialogs(xlDialogNew).Show
    End Sub

    Select Tools | Customize...
    Open the File menu,
    Right click the New... item,
    Click Assign Macro...
    Select FileNew,
    Click OK,
    Close the Customize dialog.

  5. #5
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File|New view (XL97 on Win2000/NT4)

    <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21> That does the job a treat, thank you.

    (un)stuck

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File|New view (XL97 on Win2000/NT4)

    So tell us your secret Hans: How did you find out pressing alt-2 gives a different view ?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: File|New view (XL97 on Win2000/NT4)

    Easy: from the Word MVP article in the link Stuck posted <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    I guess there must be people who try out every possible combination of keystrokes in every dialog in every Office app (or they know someone who knows someone who is on the development team inside Microsoft)

Posting Permissions

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