As part of a project I am developing, a user prints a label.
I have a new sheet inserted into the workbook and then the relevant address details pasted before the sheet is deleted. (The user does not see any of this.)
My problem is that the confirmation dialog appears when the sheet is about to be deleted, and I wonder is there a way for it not to appear. Can SendKeys statement provide a solution (but a quick search of the Forum would tend to make one steer clear of that command)?
If so how can it be used?
Leigh
