Vbokonly
5 Stories
How to keep others from printing an Excel worksheet
Techguide Excel does not offer a built-in feature that inhibits print requests, but you can use a macro to cancel print jobs.
Tags: Microsoft Office
Prevent duplicates when entering data into Excel
Techguide Duplicate values, when not valid entries, return erroneous summaries and totals. Here's what to do to prevent duplicates in a specific range using Excel's Validation feature.
Tags: Microsoft Office, MsgBox, Entry, Microsoft Excel 2007, Microsoft Excel, job, Microsoft Access, Microsoft Office, Microsoft Word, HTML
How to use the At and Ln indicators in Word's status bar
Techguide At and Ln are used in automating special format requirements. Here's what you need to know.
Tags: Microsoft Office, Form, Cell, Database, Microsoft VBA, File Menu, Microsoft Excel, Microsoft Access, window, spreadsheet
Use Wingdings to add graphics to Access forms and reports
Techguide You can insert a symbol or picture into a form or report, but embedded graphics consume a lot of resources.
Tags: Microsoft Office, Error, Microsoft Corp., Code, MsgBox, keyboard shortcut, Graphics, vbOKOnly, Alan Wood, Insert
Control where Word hyphenates a word
Techguide Follow this tip to determine where Word hyphenates your content.
Tags: Microsoft Office, Microsoft Corp., MsgBox, C, vbOKOnly, command button, Tools Menu, Microsoft Excel 2007, Microsoft Excel, Microsoft Access
