Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Different custom views on every sheets ===> (EXCEL97)

    Is this possible ?
    let say i have 3 sheets..sheet A, B and C
    on sheet A i want the custom view to
    be 80% everytime i open the wb,
    on sheet B i want the custom view to
    be 90% everytime i open the wb,
    and
    on sheet C i want the custom view to
    be 90% everytime i open the wb,
    or
    i want all the sheets to be views
    to 80% everytime i open the wb
    is there anything like vb that can do this
    many thanks

    ps: let say after user have open this wb
    they will change it to 100 %..but when they close
    it and reopen it..it will come to the view that i
    set..

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Different custom views on every sheets ===> (EXCEL97)

    Niu, You can do this! Record a macro with the name Auto_Open to setup the workbook exactly as you want it. If you want to set all of the sheets at once, you can click on the first sheet tab and shift-click on the last tab and then set the zoom. Or, you can Ctrl-Click on all the tabs that you want at 80% and then set them. Hope this helps! --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

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