You could adapt this

Select Case MsgBox("cntr=" & RecentCntr & " " _
& Application.RecentFiles(RecentCntr).Name _
& vbNewLine & "Delete?", vbYesNoCancel + vbDefaultButton2)
Case vbCancel
GoTo endpgm
Case vbYes
Application.RecentFiles(RecentCntr).Delete
MsgBox "File deleted from recent files list"
Case vbNo
' Do nothing
Case Else
' Do nothin
End Select


"XCESIV" wrote:


I would like to setup the macro to confirm they want the macro to be
performed. Can someone please help with this

The macro will be assigned to a push button on the worksheet, once the
report is complete they push the button and then i want it to create a
pop up asking "do you wish to close this report YES/NO"
if yes then peform close, if not do nothing.

thanks


--
XCESIV
------------------------------------------------------------------------
XCESIV's Profile: http://www.excelforum.com/member.php...o&userid=24271
View this thread: http://www.excelforum.com/showthread...hreadid=538473