>Hi all.
>
>How can I make VB close a workbook automatic, and not been asked if I
>want to save or delete the contents of the Clipborad.
>
>
>Jim Olesen
>


You can switch of alerts using
Application.DisplayAlerts = false
alternatively you could clear an already empty cell , to empty the clipboard

You can tell Excel that a book is saved using
Workbooks(mybook).saved = true

HTHYou'll never walk alone
Paul Felce

MVP-Excel
Jim H. Olesen wrote in message <34EA9AB5.46DD@dong.dk>...