I have a spreadsheet with an order form in it that I created that includes a customerid and address fields. I want to make sure that they can not save the spreadsheet without filling in certain cells. If the cells are populated then the SaveAs window will open.
This is what I have
.........A...............B
1...CustomerId..._____
2...Addresss......._____
3...City.............._____
4...State............_____
5...Zip..............._____
So in Cell B1is where the customerid goes,
Cell B2 is where the address goes
Cell B3 is where the city goes
Cell B4 is where the state goes
Cell B5 is where the zip goes.
Also the sheet name is 'Order Form'
I am using Excel 2003 with windows Xp SP2
This is what I have
.........A...............B
1...CustomerId..._____
2...Addresss......._____
3...City.............._____
4...State............_____
5...Zip..............._____
So in Cell B1is where the customerid goes,
Cell B2 is where the address goes
Cell B3 is where the city goes
Cell B4 is where the state goes
Cell B5 is where the zip goes.
Also the sheet name is 'Order Form'
I am using Excel 2003 with windows Xp SP2