DH Templates

can someone please help me with Microsoft Excel?

i am making a template for an invoice on microsoft excel 2003. i have entered all the information, but i want the invoice to be like an online form where you are prompted to enter the information, for example you have to enter invoice number otherwise a message comes up telling you to enter it. basically i want excel to not allow me to proceed without entering information into certain fields.

Public Comments

1. Two options 1) You need to create a template with a some VB code that when a new workbook is opened from that template the Workbook_Open event will fire and the user is led through a 'wizard' which asks the minimum questions required to fill in the invoice detail 2) You create a template and to save the invoice you have to click on a 'Save' button. The code behind the button checks all the required fields and saves it if OK and presents a warning if not. If you need any further help flick me an email
2. Let's say B4 is the cell to enter data first then C6. The code below will prompt the user that he cannot proceed to C6 without filling up B4 first. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$C$6" Then If IsEmpty([B4]) Then Beep MsgBox "You must enter data in B4 before selecting this cell" [B4].Activate End If End If End Sub