View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bunnyboy Bunnyboy is offline
external usenet poster
 
Posts: 4
Default Restrictions on Addresses

Hey

We currently use a spreadsheet on office 2003 to store a large amount of
personal information regarding property work. This spreadsheet is populated
by opertives who answer phone calls and enter the information onto it,
Recently we have found some sites that are no longer covered by us.

I was thinking if we could put a restriction on the spreadsheet so when an
operative tries to enter an address that is restricted then it will bring up
a warning to say that its restricted and a reason why.

Can this be done?

Hope to hear from you soon.

James
(Technology Officer)