Thread: SAVE AS MACRO
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ninja Stevie Ninja Stevie is offline
external usenet poster
 
Posts: 3
Default SAVE AS MACRO

There is a problem with your VBA code (the macro).

if you open up your visual basic editor, and look at the module
containing the code (or click debug when you get this message, you want
to insert the following code (but adapt it accordingly)

If(whatYouTyped="no") Then
MsgBox "File not overwritten."
Exit Sub
End If