Hi there,
have following code:
ChDir "M:\"
ActiveWorkbook.SaveAs Filename:= _
Application.InputBox("Enter Save as File Name") & ".xls" _
, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
works fine but is there a way to disable the Close button in the box? If I
click on it it saves the file as False. Also, if I click on Cancel button it
saves as False. So what I want is that if the user clicks on accident on the
Close button that nothing happens and if they click on Cancel button to mayve
have a message saying Must Type File Name. This way it will force the users
to put somethin instead of the file saving as False.
Any ideas?
Really appreciate.
Juan