Results 1 to 6 of 6
  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Professional look & feel (2002)

    I'm looking for inspiration, tips, direction.......

    I have several excel workbooks that are built to be kind of like templates. I'd like to think that they are built robustly, foolproof, user friendly....(with lots of lounge help <img src=/S/wink.gif border=0 alt=wink width=15 height=15>). I would like to take them to another level, to give them more of a professional look and feel. How can I make them look less like excel workbooks and more like professional applications?

    I'm not sure that this is possible but I would appreciate any comments.

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

    Re: Professional look & feel (2002)

    You can hide the gridlines, and guide the user through a worksheet by a restrained use of borders, font formatting and fill colors. Avoid garish colors, pastels are generally to be preferred.

    You can also hide the row and column headers, the sheet tabs (if you have multiple sheets, you'll want to provide alternative means of navigating between the sheets), the scroll bars (only if the users won't need to scroll) and the formula bar (only if users don't need to enter or edit formulas themselves)

    A custom toolbar can be helpful; you should ensure that it is only available when your workbook is open - see for example Toolbars by <!profile=Pieterse>Pieterse<!/profile>.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: Professional look & feel (2002)

    Building on what Hans said.

    Make sure that when the Workbook Opens the View is Full Screen.

    You should consider a "Welcome" Area. Which is a Worksheet that has your professional Graphics and Design and is the first thing seem by the User. This sheet should be protected and have either Hyperlinks or A "Continue" Button directing the User to the next area of the Workbook.

    Using VBA you can control the Excel Look and Feel when the User arrives at the next destination. In other words, if the User will need Rows and Columns turned on, Grid Lines turned on, Toolbars Opened Etc., you should have VBA change Excel to show the needed items.


    Regards,

    Tom Duthie

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Professional look & feel (2002)

    In addition, since you will probably want the macros enabled and the workbook not that useable without the macros enabled, If you use Tom Duthie's suggestion, you can have only that worksheet visible and the rest veryHidden. You can have a message on the screen indicating that macros must be enabled.

    You would have the macros remove the message and unhide any necessary sheets.

    Steve

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

    Re: Professional look & feel (2002)

    On top of Hans' suggestion on borders and stuff, take a look at this article on styles .

    In my experience, using styles has the interesting side effect of improving the look of your file to a more profesional level.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Professional look & feel (2002)

    Thanks for all the suggestions and links, some interesting reading!

Posting Permissions

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