I have a macro that prompts the user to make a new workbook on startup,
would it be possible to stop the macro using an if statement that says if
this book has any other filename other than the origanl =vbno ?

I think what you want is quite straight-forward. In your existing macro you
need to add something like the following before it gets down to business...

if not activeworkbook.name = "blahblahblah.xls" then
exit sub
end if

where blahblahblah.xls is the only workbook where the macro isn't stopped.

"phuser" wrote:

> I have a macro that prompts the user to make a new workbook on startup,
> would it be possible to stop the macro using an if statement that says if
> this book has any other filename other than the origanl =vbno ?
>
>
>

Sweet!! Thanks so much


"Sam Wilson" <(E-Mail Removed)> wrote in message
news:9ACC180A-1EE7-439D-BC28-(E-Mail Removed)...
>I think what you want is quite straight-forward. In your existing macro you
> need to add something like the following before it gets down to
> business...
>
> if not activeworkbook.name = "blahblahblah.xls" then
> exit sub
> end if
>
> where blahblahblah.xls is the only workbook where the macro isn't stopped.
>
> "phuser" wrote:
>
>> I have a macro that prompts the user to make a new workbook on startup,
>> would it be possible to stop the macro using an if statement that says if
>> this book has any other filename other than the origanl =vbno ?
>>
>>
>>