i am creating a macro whereby i take the contents of several worksheets and
compile a final workbook. i have a template of the final workbook whereby i
do a lot of cell calculations rather than clutter the excel macro.

so when i populate the template, i get my calculations performed

when i was building the macro, i got screen messages that indicated i had
lots of info on the clipboard and did i want to delete or save. i deleted.
when i run the macro, i get these screen messages. how do i get rid of the
messages

at the start of the code try:

application.displayalerts = false

--
Message posted via http://www.officekb.com

thanks

"jnewl" wrote:

i am creating a macro whereby i take the contents of several worksheets and
compile a final workbook. i have a template of the final workbook whereby i
do a lot of cell calculations rather than clutter the excel macro.

so when i populate the template, i get my calculations performed

when i was building the macro, i got screen messages that indicated i had
lots of info on the clipboard and did i want to delete or save. i deleted.
when i run the macro, i get these screen messages. how do i get rid of the
messages