I have used a message box in the auto open macro that prompts to
update tthe data or not.
It ahould be placed at the beginning of your auto open macro

'message box to update or not
Dim Msg, Title, Response As String
Msg = "Do you want to update the data?"
Title = "Update new data"
Response = MsgBox(Msg, vbYesNo + vbQuestion, Title)
If Response = vbNo Then
Exit Sub ' Quit the macro
End If


On Apr 3, 5:22*pm, Phil Smith wrote:
I want a Macro to run when a spreadsheet is opened SOME OF THE TIME. *I
know about Auto_Open but it runs everytime you open the spreadsheet. *I
do not want this. *I want to be able to decide, based on a command line
call, whether or not to run the macro in question.

Excel 2003.

Ideas?