-
VBA to force paste special
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules