Dropdown box

M

markelbourno

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?
 
T

Tieske

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
 
Top