Clipboard gets emptied when VBA runs

Hi,

In my production workbook I've got code similar to the following excerpt:

Please Login or Register  to view this content.

So, in most cases, activating a worksheet re-protects the worksheet (UserInterfaceOnly) if it's not already protected. Note: the protection is just meant to keep the end user from shooting him/herself in the foot. There is no password on the worksheet protection; the end user can unprotect the worksheet if needed.

I thought conditionally executing the protection would keep the clipboard intact, but this doesn't appear to be the case.

What's irritating the end user is the inability to copy a cell value from one worksheet to another, in particular to the Money tab. When he clicks on the Money tab, the worksheet gets re-protected (if necessary), and the formulas are re-calculated. At which point the clipboard is empty, and he can't copy into the Money worksheet.

Why does executing VBA clear the clipboard - surely Microsoft could fix this??? Is there any workaround for this issue short of re-architecting my application?

Thanks,
Scott

P.S.: The reason it's coded this way is the vast bulk of the code is in a class module in an XLAM add-in. This approach was the only way I could get it to work. It's klunky but functional (and ultimately off-topic to my main question).

try to see whether this will help you: http://stackoverflow.com/questions/1...code-execution