dear colleagues,
i created a data collection sheet with loads of conditional formattings in order to support the users and to save time for feedback loops. the problem is that copied values overwrite conditional formattings and thus make them useless. i found a script online with which i can force to paste only values by using strg+v and right mouse button + paste. but unfortunately there are a few paste options which are not affected by the script and could cause trouble. the relevant rows in the code are:

Excel.Application.OnKey "^v", m_sPasteProcedure_c
Excel.Application.OnKey "+{INSERT}", m_sPasteProcedure_c

do you have an idea, how i could force paste value for every paste option?

thanks for your help!

best
daniel