Thanks Jonathon, On Tuesday 02 August 2005 07:02, Jonathon Coombes wrote: > On Tue, 2005-08-02 at 06:34 +0200, Chadley Wilson wrote: > > Greetings > > > > I was wondering, I would like to restrict the contents of the cells in a > > specific column. > > > > Let me explain, in my case for column P, the user must only be able to > > type in branch codes, the branch codes must be predefined through a drop > > down list. > > > > The reason is that I will be using countif combined with sum to calculate > > the totals that we have produced for our branches. > > Could someone please tell me what we call this and if possible provide > > and example of how to set it up? > > Hi Chadley, > > This is quite simple in the newer 1.9 (2.0 beta) series of > OpenOffice.org. Simply go to Data -> Validity and choose the > list criteria. Specify your required branch codes and the column > is set. > > If you are using 1.x series, then to use Validity in a similar > way, you will have to trap all entries and then do it through a > macro event handler. > > Regards > Jonathon
-- -- Chadley Wilson Production Line Superintendant Pinnacle Micro Manufacturers of Proline Computers ==================================== Exercise freedom, Use LINUX ===================================== --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
