Thank you guys,

Well I have to tell you I freaked out for no reason. Apparently Excel will delete my clipboard info only if the information comes from the same file or any workbook within Excel itself. If I copy data from lets say Internet explorer then protecting and unprotecting the workbook will not affect the clipboard.

Since my data is coming from another application then, I have no issues at all.

Thanks a lot for the help guys. I will definitively look into the matter even further.