Monday, November 30, 2015

Dictionary means - never having to say huh?

Google dictionary


"To see a definition for a word or phrase, simply type the word "define," then a space, and then the word(s) you want defined. If Google has seen a definition for the word or phrase on the Web, it will retrieve that information and display it at the top of your search results.

You can also get a list of definitions by including the special operator "define:" with no space between it and the term you want defined. For example, the search [define:World Wide Web] will show you a list of definitions for "World Wide Web" gathered from various online sources."

Also check out http://wordweb.info/



"WordWeb Pro is a quick and powerful international English thesaurus and dictionary for Windows. It can be used to lookup words from almost any Windows program, showing definitions, synonyms and related words. There are also many proper nouns and usage examples. You can search for words matching a pattern, find and solve anagrams, and optionally search a large number of extra word lists."




See all Topics

Sunday, November 29, 2015

Data Modeling

Data bits and pieces

While a few of us may be guilty of constructing databases on the run, and then trying to clean up the mess later, the wise ones plan ahead.

What information will you need in the future? What reports are going to be requested? If you're the bean counter, do you need to count all the legumes?


"Data modeling is probably the most labor intensive and time consuming part of the development process. Why bother especially if you are pressed for time? A common response by practitioners who write on the subject is that you should no more build a database without a model than you should build a house without blueprints.

The goal of the data model is to make sure that the all data objects required by the database are completely and accurately represented. Because the data model uses easily understood notations and natural language, it can be reviewed and verified as correct by the end-users.

The data model is also detailed enough to be used by the database developers to use as a "blueprint" for building the physical database. The information contained in the data model will be used to define the relational tables, primary and foreign keys, stored procedures, and triggers. A poorly designed database will require more time in the long-term. Without careful planning you may create a database that omits data required to create critical reports, produces results that are incorrect or inconsistent, and is unable to accommodate changes in the user's requirements."


AgileData.org:
Data Modeling 101



See all Topics

Saturday, November 28, 2015

Digitally Sign

Messages

If you have a need to protect the contents of your email messages, these links should point you in the right direction.


Outlook supports the following features for cryptographic messaging:
Digitally sign an e-mail message. Digital signing provides nonrepudiation and verification of contents (the message contains what the person sent, with no changes).

Encrypt an e-mail message. Encryption helps to ensure privacy by making the message unreadable to anyone other than the intended recipient.

There are additional features that can be configured for Outlook 2003 for security-enhanced messaging, if your organization chooses to provide support for them, including:

Sending an e-mail message with an S/MIME receipt request. This helps to verify that the recipient is validating your digital signature (the certificate you applied to a message).

Adding a security label to an e-mail message. Your organization can create a customized S/MIME V3 security policy which can add labels to messages. An S/MIME V3 security policy is code that you add to Outlook that runs automatically to add information to the message header about the sensitivity of the message content. For example, an Internal Use Only label might be applied to mail that should not be sent or forwarded outside of your company.



Overview of Cryptography


Free digital ids

Slipstick.com:
Encryption and Message Security Tools

TheTechGap.com:
Digital IDs in Outlook

Adobe:
Digital IDs



See all Topics

Friday, November 27, 2015

Page Numbers

A baker's dozen of ideas


Here is a collection of tips about how to display information in Headers and Footers.

Field codes are demonstrated. Remember that the brackets {} must be inserted with Ctrl+F9, not directly from the key board.

Here's one suggestion:

Display the word "more" at the bottom of every page except the last page.

Insert an "if" field into the footer.

The field in this case will be a compound entity that consists of two fields nested within a third field.

{ IF { PAGE } = { NUMPAGES } "" "more" }
  1. Position cursor where you want the field.
  2. Press Ctrl+F9 to insert the field braces.
  3. Type the field expression as it appears below, using Ctrl+F9 and arrow keys as needed to keep text within the various braces as you type.
    { IF { PAGE } = { NUMPAGES } "" "more" }
  4. Select the entire expression.
  5. Right-click the selection and choose Toggle Field Codes.
    (or use Alt+F9)
Headers and footers and page numbers



See all Topics

Thursday, November 26, 2015

Dynamic AutoShape Link

Show the star

Here's a hint that I had forgotten about.

You can tie the result of a cell to an AutoShape.

This displays the value in a more dramatic manner.
  1. Create an AutoShape on the Worksheet
  2. With the shape selected, type an equal sign in the formula bar.
  3. Enter the address of the linking cell (or click the cell)
  4. Hit Enter


Thanks to AutomateExcel.com for the reminder.



See all Topics

Wednesday, November 25, 2015

Photo Gallery

A CSS exercise


FrontPage had a Photo gallery template, and you can also save a PowerPoint show as a web page.

For another take on the problem, here are the instructions needed to create a gallery using CSS.

Click here to see what it might look like:



How to Create a Photographic Gallery Using CSS
By Stu Nicholls



See all Topics

Tuesday, November 24, 2015

Zapf Your Own Dingbat

Private Character Editor


Windows has its own, hidden, character creator, called the Private Character Creator .


Using Private Character Editor (PCE), you can create up to 6,400 unique characters (such as special letters and logos) for use in your font library. PCE contains basic tools for creating and editing characters, along with more advanced options.

If you want to create a new private character using an existing character as your model, you can copy the existing character to the Edit grid and then modify it to suit your needs, or you can display the existing character in a Reference window alongside your Edit grid for use as a visual reference. You can use any character from any font that is installed on your computer.


The Private Character Editor is accessed at Start>Run and enter "Eudcedit" without the quotes.
After you have constructed and saved the design of your choosing, you can access it from the Character Map by selecting Start>Run "Charmap".

Drop the Font selection list down and choose All Fonts (Private Characters), then click on the character you have created, copying and pasting it into any document.

Hermann Zapf designed some of the 20th century's most important fonts, including Palatino and Optima. He also produced a collection of decorative symbols called "dingbats", modeled after the accidental lead drippings collected by old style typesetters.

Also:
Private Character Editor — Eudcedit
By Vic Laurie

Keyboard Utilities for Windows
Alan Woods



See all Topics

Monday, November 23, 2015

Can We Serve Multiple Masters?

Dual Masters and more schemes


Earlier versions of PowerPoint were restricted to only one master design scheme per show. We strained to get around that by linking shows and pasting backgrounds over the designs.

PowerPoint 2002+ changed that by allowing more than one design scheme.

A PowerPoint master with the first name of "Echo", runs a nice tutorial site named EchosVoice.com.

She has written a step-by-step tutorial to create Multiple Masters for PPT 2002 and beyond.

Makes you want to dance. (Echo's own image)
Echo Dancer



See all Topics

Sunday, November 22, 2015

Rewind DVDs

Speed the process


Sometimes one finds a solution to a problem that is not seeking an answer.

"Guaranteed Lowest Price on the Internet for DVD Rewinding
No More Embarrassing Fines or Hassles at your Video Rental Store !!!
No Fuss — No Waiting — Do It Online — Do It Now!
Rewind your DVDs


Digital Velocity



DVD Rewinder



See all Topics

Saturday, November 21, 2015

Other Right Clicks

A couple overlooked


Right-clicking on objects, such as Tables, Reports or Queries, gives you the opportunity to print, copy, and work with them.

There are other options revealed by right-clicking on the Database window itself.
Right-click on the empty white space of the Database window can lead to Relationships.



If you right-click on the edge of the window, you'll find a link to Access database properties, startup activity for the current database, or open a new database.

Right-clicking on the Database window also lets you configure the items in the Groups bar.



See all Topics

Thursday, November 19, 2015

Automate Word Tables

VBA examples and instructions


The Microsoft Developer's Network has a pretty comprehensive article on programmatically working with data and Word tables.

"You can look at the world as split into applications that store data (databases) and applications that present information, such as Microsoft Office Word 2003 and Microsoft Office PowerPoint 2003. Increasingly, the end user demands to display database content in documents and presentations.

While Word does provide some tools for displaying tables from databases in its documents, these are somewhat rudimentary, they require a basic understanding of how the database is built, and using them involves a number of steps. In addition, there may also be security and access issues involved, requiring additional layers of protection.

The developer is therefore increasingly confronted with the task of transferring data into Word, whether in the form of tables, or as part of the document text. This article considers some of the major aspects of using the Word object model to work with tables."


  • Introduction to Automating Tables
  • Creating Tables Programmatically in Word
  • Populating Word Tables with Data
  • Adding Linking in Word Tables Programmatically
  • Extracting Data from Word Tables Programmatically
A downloadable document is also available for those of us still addicted to paper. Automating Word Tables for Data Insertion and Extraction.



See all Topics

Wednesday, November 18, 2015

Internet 099

Basics and Beyond


A San Francisco company called Learn the Net has produced a basic on-line tutorial about the Internet.

If you need a fundamental primer, this might be a place to look.

It is not a series of scaled down "baby talk" lessons. You can drill down though the meaning of 403/404 error codes and links to WW3 Generic URI Syntax (RFC 2396) standards.

That is if you know how to drill down.

"Throughout Learn the Net--in fact on most web pages--you will see words that are in color and often underlined. By clicking on these words, known as hypertext, you jump to other places on the page, to other pages on the site, or to other resources on the Internet."


www.LearntheNet.com



See all Topics

Tuesday, November 17, 2015

Don't Display

Logon, Logoff, Startup and Shutdown Status Messages


To turn these off:

Start Regedit
Go to

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\system
If it is not already there, create a DWORD value named DisableStatusMessages

Give it a value of 1

To turn on:

Locate and then click the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System
On the Edit menu, point to New, and then click DWORD Value.

Type verbosestatus, and then press ENTER.

Double-click the new key that you created, type 1 in the Value data box, and then click OK.

Quit Registry Editor.

NOTE: Windows does not display status messages if the following key is present and the value is set to 1:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System\DisableStatusMessages

Verbose Status Messages



See all Topics

Monday, November 16, 2015

Kürzungen für jeder

Accessibility Shortcuts


Several resources are available to help increase speed and effectiveness for keyboard users. Here are keyboard shortcuts for leading Microsoft products that help save time and effort and provide an essential tool for some people with mobility impairments.

  • Internet Explorer (11/10/9/8/7/6)
  • Office (2013/2010/2007/2003)
  • PowerPoint
  • Publisher
  • Windows (8/7/Vista/2003/XP/2000)
  • Windows Media Player
Microsoft.com Keyboard Assistance.



See all Topics

Sunday, November 15, 2015

Free Excel Templates

Financial enlightenment


Matt H. Evans CPA. CMA, CFM has complied a list of 117 free Excel spreadsheets devoted to financial matters.

Here are a few of the entries:
Time Value (xls)
Introduction to time value concepts, such as present value, internal rate of return, etc.
Lease or Buy a Car (xls)
Basic spreadsheet for deciding to buy or lease a car.
Top Five NPV & IRR (xls
Explains Internal Rate of Return, compares projects, etc.
Statements (xls)
Generate a set of financial statements using two input sheets - operational data and financial data.
Business Financial Analysis Template
for start-up businesses from Small Business Technology Center
Income Statement
What If Analysis
Assessment Templates
Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model.


ExInfrm.com



See all Topics

Saturday, November 14, 2015

Sort Forms

Create a sorting function

Here is one way to provide your users with a means to reorder fields in forms.

"Chris Weber develops a solution that allows users to sort the data in their forms (or subforms) that you can add to your application easily.

  • The sorting interface should be generic to any form in any database.

  • It should also work with subforms.

  • It needs to be implemented as expediently as possible to fulfill the bid, and be easily maintained in the future.

  • It should be intuitive or reminiscent of other interfaces in Access and Windows.
Let Your Users Sort it Out



Scroll down to the bottom of the page. There is a file that can be downloaded with the code.



See all Topics

Friday, November 13, 2015

More Tips on Presentations

From another point of view


"Holding the honorary title of "Microsoft Regional Director" for Chennai over the last 6 years, I have delivered hundreds of presentations and lectures. Doing this, I have learned that doing successful presentations is an Art, which can be acquired only over time and by practice."

Venkatarangan, Chennai, India


There are 3 basic ways to learn this art:
  1. Listen to great speakers: Attend as many programs of great speakers as possible. Subject spoken is immaterial here, what you are learning is the "Master's" way of doing it.

  2. Read about doing presentations: There are now plenty of books on doing effective presentations and Internet has numerous pages on this. Read them.

  3. Keep Doing it: Get on stage as many times as you can and just do it. As they say, your mistakes teach you more than anyone. So as you keep doing more and more presentations, you will learn on your mistakes and improve.
Also:
  • General Tips:
  • Health/Life Style Tips:
  • Doing Technical Presentations:
  • Authoring Power Point Slide-Decks:
  • Laptops, Audio-Video & Systems:
  • Sharing the stage:
  • Answering Questions — Q & A:
Venkatarangan's Blog



See all Topics

Thursday, November 12, 2015

Mail Merge Page Printing

One big page


After completing a merge to a new document, the status bar may indicate that the insertion point is located on page 1 of 38 pages. This is a bit of mis-information.

If you turn on Show/Hide and look at the merged document in Normal view, you'll see that the merged document has section breaks rather than page breaks.

If you try to print what should be Page 1, the entire document will print.

To print just the first section, use "s1" in the Print dialog box.



Another way to handle it is to go to Edit>Replace and replace

"^b" (section break)

With

"^m" (manual page break)



From Office.Microsoft.com:
In the Pages box, type instructions to print one of the following:

Noncontiguous pages

Type the page numbers with commas between them. Type the range of pages with a hyphen between the starting and ending numbers in the range. For example, to print pages 2, 4, 5, 6, and 8, type 2,4-6,8
A range of pages within a section

Type p page number s section number. For example, to print pages 5 through 7 in section 3, type p5s3-p7s3
An entire section

Type s section number. For example, type s3
Noncontiguous sections

Type the section numbers with commas between them. For example, type s3,s5
A range of pages across sections

Type a range of page numbers and the sections that contain them with a hyphen between the starting and ending numbers in the range. For example, type p2s2-p3s5




See all Topics

Wednesday, November 11, 2015

Graphics from the '50s

Remember it the way you want to


Original fifties clipart? Just in time for the holidays, some Ozzie and Harriet style pics.



"Most communities in the fifties had small town print shops that doubled as printers of local news and advertising papers. These printers could not afford graphic artists so they used stock clipart supplied by large companies who distributed common graphics for use in advertising sections of the papers. They were provided for the printer in lots of categories to meet any advertiser's needs."

Retrographix.com



See all Topics

Tuesday, November 10, 2015

EMail Substitute Icons

Foil the spoilers


If you include an email address it can be read be the evil robot of the web.
Nexodyne.com will create a free email icon graphic to be used in place of a mail hyperlink.



You could also use this piece of Javascript to avoid R2D2.

(user in this case would be "MyJunkMail.Place"
mydomain would be "Gmail.com")


<script language="JavaScript">
<!-- Begin
user = "myaddress";
domain = "mydomain";
document.write('<a href=\"mai' + 'lto:' + user + '@' + domain + '\">');
document.write(user + '@' + domain + '</a>');
// End -->
</script>
<noscript>
Here goes some text that can be seen if Javascript is disabled.
</noscript>


(from SB Projects.com)



See all Topics

Monday, November 09, 2015

Better PowerPoint Presentations

More suggestions


There are never enough tips for successfully communicating information.

Michael Hyatt has these guidelines:

I like the first rule. The purpose of the meeting is to communicate information, not to demonstrate your prowess with a piece of software.

Rule #1:
Don't give PowerPoint center stage.
Rule #2:
Create a logical flow to your presentation.
Rule #3:
Make your presentation readable.
Rule #4:
Remember, less is more.
Rule #5:
Distribute a handout.


Michael Hyatt is the President and Chief Operating Officer of Thomas Nelson Publishers, the largest Christian publishing company in the world and the ninth largest publishing company of any kind.

Five Rules for Better PowerPoint Presentations



See all Topics

Sunday, November 08, 2015

Java and All That Jazz

Free code


One way to jazz up a boring web site is to use scripting to present random images or create interesting menus. You could learn to do it yourself, or borrow from the stars.

JavaScript-2.com is a source for free JavaScript Codes.

Find FREE JavaScript codes quickly and easily with the only search engine that searches all the top Java Script libraries, offering a total of over 8,000 free JavaScripts.



See all Topics

Saturday, November 07, 2015

Sudoku

CrossNumber puzzles


I have to admit that I have not caught the fever that these puzzles seem to have generated.

Most every newspaper in the world has started publishing these brain teasers.


"Sudoku , sometimes spelled Su Doku, is a logic based placement puzzle, also known as Number Place in the United States. The aim of the canonical puzzle is to enter a numerical digit from 1 through 9 in each cell of a 9x9 grid made up of 3x3 subgrids (called "regions"), starting with various digits given in some cells (the "givens"). Each row, column, and region must contain only one instance of each numeral.
Completing the puzzle requires patience and logical ability. Its grid layout is reminiscent of other newspaper puzzles like crosswords and chess problems.
Although first published in 1979, Sudoku initially became popular in Japan in 1986 and attained international popularity in 2005."


Wikipedia — Sudoku

Here is a download that will construct as many of these puzzles as you might be Jonesing for.

Andy Pope Su Doku


Also:

Web Su Doku



See all Topics

Friday, November 06, 2015

Dvorak Anyone?

Alternative Keyboard Layouts

"Free keyboard layouts - called Dvorak layouts - are available for people who type with one hand or finger. These layouts make the most frequently typed characters on a keyboard more accessible to people who have difficulty using the standard keyboard layout (called the "QWERTY" layout).

Dvorak keyboard layouts reduce the amount of motion required to type common English text. Use of these layouts may also help avoid some types of repetitive strain injuries associated with typing.

Studies have also shown an increase in typing speed and accuracy when using the Dvorak layout for two hands. The left-hand or right-hand keyboard layouts can also be useful for people who type with a wand."


You do not need to modify your hardware keyboard to use these layouts, but you will need to change your keyboard settings to use the Dvorak layouts.

(A keyboard layout is a map or a definition of how keys are laid out on your keyboard. The keyboard layout you use is determined by software in your computer. The letters on your keys indicate the standard layout for your keyboard.)

Tutorials and downloads


Dvorak layouts

Introducing the Dvorak Keyboard
By Marcus Brooks

A Brief Primer
by Randy Cassingham



See all Topics

Thursday, November 05, 2015

Merge Pictures

Different picture to every letter in a mail merge



A variation of this technique could also be used with an IF statement to display different pictures based on some criteria, such as Zip code.
  1. Open the Excel worksheet that you use as the mail merge data source.

  2. Insert a new column that has a column heading such as Picture.

  3. For each row of the Excel worksheet, insert in the Picture column the path and the file name of the picture that you want to use for that record of the data source. Additionally, enclose the path and the file name in quotation marks (").

    For example, copy the path and the file name of the picture in Windows Explorer. Then, paste the path and file name into the Excel worksheet.

    Note The path and the file name of each picture in the Picture column will appear similar to the following example:


    "C:\Documents and Settings\username\My Documents\My Pictures\foldername\filename.jpg"

  4. On the Edit menu, click Replace. Then, replace each instance of a single slash mark (\) with double slash marks (\\) in each path.

    For example, each path should now look similar to the following example:

    "C:\\Documents and Settings\\username\\My Documents\\My Pictures\\foldername\\filename.jpg"

  5. Save and then close the Excel worksheet. Then, quit Excel.
In Word, follow these steps:
  1. Open the mail merge main document.

  2. If the Excel data source is not attached, attach the data source. To do this, go to Step 3 of 6 in the Mail Merge task pane. Click Browse, and then attach the Excel data source.

  3. Click Next: Write your letter.

  4. In the mail merge main document, move the insertion point to the location where you want the picture to appear.

  5. On the Insert menu, click Field.

  6. In the Field dialog box, click IncludePicture under Field names, and then click OK.

    Note You may receive the following error message:

    Error! Filename not specified

  7. Press ALT+F9 to display the field codes in the mail merge main document. You will see a field that is similar to the following field:

    { INCLUDEPICTURE \* MERGEFORMAT }

  8. Move the insertion point into the field immediately following INCLUDEPICTURE.

  9. Press the SPACEBAR, and then click More items on the Mail Merge task pane.

  10. In the Insert Merge Field dialog box, click the picture merge field, such as Picture, and then click Insert.

  11. Click Close to close the Insert Merge Field dialog box.

    The INCLUDEPICTURE field should now look similar to the following field:

    { INCLUDEPICTURE { MERGEFIELD "Picture" } \* MERGEFORMAT }

  12. Press ALT+F9 to hide the field codes in the mail merge main


  13. Click Next: Preview your letters.


  14. Click Next: Complete the merge.

  15. In the Mail Merge task pane, click Edit individual letters.

  16. In the Merge to New Document dialog box, click OK.

  17. On the Edit menu in the merged document, click Select All.

  18. Press F9 to update the fields in the merged document.
    (Word mail merges are not dynamic)

  19. To print your letters from the merged document, click Print on the File menu. Each printed letter will contain the picture that you specified in the Excel data source.
Knowledgebase #909132:
Different picture to every letter in a mail merge



See all Topics

Wednesday, November 04, 2015

Normalization

Designing an efficient database

Here is an understandable article about how to put together a normalized database.

One topic covered is what should be used for a Primary or foreign key.
"In general, a key field should have these characteristics:

Should be One Field

It is possible to define multiple fields as the key fields of a table, but a single field is preferable. ...Far better to have a CustomerID number than a combination of other fields to define a customer.
Should be Numeric

Access offers an AutoNumber field that is a Long Integer which is ideal for key fields. These values are automatically unique for each record and supports multi-user data entry as well.
Should Not Change Over Time

A key field should not change over time. Once identified, like a social security number, it should never change.
Should be Meaningless
To ensure a key field doesn’t change over time, it should have no meaning and therefore no reason to change over time.


Here are a few of the other topic headings:

Understanding Your Data
  • What Data Do You Need?
  • What Are You Going to Do with the Data?
  • How Is Your Data Related to Each Other?
  • What Is Going to Happen to the Data Over Time?
  • Learn How to Use Queries
Database Normalization Tips By Luke Chung, Founder and CEO of FMS Inc
Also see: Knowledgebase #283878:
Description of the database normalization basics
and:
Normalization Model



See all Topics

Tuesday, November 03, 2015

How to Burn Out Your Audiance

Audience antagonizers


What are the three most annoying things about bad PowerPoint presentations?

"According to the survey, conducted on the CommunicateUsingTechnology.com web site, the most common complaints are:
  • Speakers reading their slides to the audience (71.7% of respondents cited this item),
  • Text on the slides is too small to be readable (47.7%)
  • Visuals too complex (36.9%) and
  • Full sentences were used instead of bullet points (48.6%).
  •  
    This survey is one of the first to investigate how presentations are seen from the audience point of view. Of those respondents who see 100 or more presentations per year, more than half said that 50% or more of the presentations they see suffer from one or more of the annoying traits. The costs of poor presentations are in the time wasted by those who attended and in the extra work that must be done to communicate the intended message again since it was not done properly the first time."
CommunicateUsingTechnology.com:
Annoying PowerPoint Survey



See all Topics

Monday, November 02, 2015

Light Up Where You Live

A nation's porch light


"Ben Fry is a doctoral candidate at the MIT Media Laboratory. His research focuses on methods of visualizing large amounts of data from dynamic information sources. This work is currently directed towards "Genomic Cartography" which is a study into new methods to represent the data found in the human genome."

He has a fascinating demonstration of data display technique:



Zip Code Demonstrator.

Type in a zip code one number at a time to see how zip codes are distributed in the US.



See all Topics

Sunday, November 01, 2015

Spreadsheet Design

Make it work and look good


Timothy Miller uses the nom de screen of "Jethro" (Moses' Father-in-Law).

His SpyJournal.biz site/blog gives some tips on how to present an Excel solution


Design and layout

One of the easiest ways to set up spreadsheets that calculate or generate results that need to be reported is to separate the function from the form. Just like a shiny exterior on a car hides the internal engine and wiring. I always create my reports and front end menus to look good and generate results and calculations in more functional sheets.
Hiding unnecessary sections

If you must have calculations and working sections visible, then hide the unnecessary bits. Hiding a row or column is only one way of doing this. Using the group function you can rollup whole rows of information, e.g. components that add to a subtotal or constants and variables such as exchange rates, interest rates, and other indexes.
Use of colour and graphics

I like to use the company logo or other graphic as a design element in my spreadsheet. Sometimes I do this by using the corporate colours, other times by using the graphic itself. If I have a spreadsheet with a lot of macro buttons, I may use command objects and use the logo as a picture on the button.
Removing excel components

There are a number of excel components that you can turn off. Menu screens and reports screens may not need horizontal or vertical scroll bars, sheet tabs or row and column headings. Using macro buttons to return to a menu can overcome the need for sheet tabs. Not displaying gridlines will give a clean uncluttered look to a layout, and then using borders as necessary can create emphasis in the right areas.

You'll find the complete text here:
Design Presentation Tips

Also see:
The Art of the Spreadsheet



See all Topics