View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AD108 AD108 is offline
external usenet poster
 
Posts: 72
Default Validate WorkBook name

I want to use the "Before Save" event to force users to save a template with
a certain naming convention. (The name must contain the words Air
Container)

Is this possible. For example in the Before Save event procedure it may say
something like

If WorkBook.Name < "*Air Container*" (if true then it would prevent the
save from completing.)

Thanks in advance
AD108