LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default input template

i have seen formatting that looks like a lightswitch cover in a house: a
plastic plate w/ rectangular holes where the lightswitches come out. on a
spreadsheet, this is used to make it obvious where you are to input data
(the rectangular holes, or cells) and obvious where you are NOT supposed to
input data (the plastic plate, or protected unwritable cells).

say i want to only allow inputs in cells a4, a5, d4, and d5 and not allow
inputs in any other cell on the sheet. i know i can protect all but these
4, then shade w/ colors, bold, etc. but it doesn't look as good/professional
as this "plate" effect. any thoughts? thanks, mike allen


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL INVOICE TEMPLATE THAT UPDATES DATA AS I INPUT ITEM# zamberwe Excel Worksheet Functions 1 October 7th 09 02:36 AM
create template with certain fields to input information only Annette Excel Worksheet Functions 2 May 19th 06 03:54 PM
Where can I get an excel template to input annual leave? Tetley Excel Discussion (Misc queries) 1 November 30th 05 11:32 AM
Opening a template form & renaming it from a cell input automatica John Galt Excel Discussion (Misc queries) 0 April 19th 05 09:16 PM
CODE to select range based on User Input or Value of Input Field Sandi Gauthier Excel Programming 4 December 8th 03 03:22 PM


All times are GMT +1. The time now is 04:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"