Removing Excel promits from a macro

Hi
I am writing a macro that will split text from a database file in to a formatted excel spreadhseet. I can write the macro so that it works, but excel keeps asking me questions (like do i want to clear my clipboard). Is there anyway i can program a response in to the macro so that it doesnt ask me these questions (for example i never want to keep the clipboard info, so it just enters 'no' rather than me having to).

Thanks