Dropdown box
 

I have a spreadsheet with 6 drop down boxes. Is there away to make the
dropdown boxes in a specific default every time another user opens it?

Dropdown box
 

Create a macro in your workbook. The below example will set cell A1 to 0
everytime the workbook is opened. Alter this to modify the values your drop
down boxes are linked to.

Private Sub Workbook_Open()
Range("A1").Select
ActiveCell.FormulaR1C1 = "0"
End Sub

Tieske


wrote in message
ups.com...
I have a spreadsheet with 6 drop down boxes. Is there away to make the
dropdown boxes in a specific default every time another user opens it?