I have a workbook with a small macro routine on sheet1 that is run on a Worksheet_activate event. This clears the clipboard, meaning it is impossible to paste anything into the sheet.
Any ideas on how to make pasting possible?
PS. The macro needs to run as soon as the worksheet is activated, so a worksheet_change event is out of the question.
Any ideas on how to make pasting possible?
PS. The macro needs to run as soon as the worksheet is activated, so a worksheet_change event is out of the question.