Copy to Clipboard in VBA no longer working

[markkuznetsov1]

Hello, this is my first macro based workbook so please answer in laymans terms if possible. This workbook basically is button based that produces a "next number" and spits out date/time and user who clicked as well. It also should copy the produced number to clipboard to manually enter in another program. I have a separate sheet "AuthUsers" to type in users that are authorized to both, use in read/write and click the button. Everything worked flawlessly today until after I tried to protect the sheet. I first protected the auth users column with Review: Protect : Allow Edit Range (also added myself and another user to not require password to change cells). Then I protected the number generating sheet but unprotected after I realized it protects the button as well. The last thing I did before I noticed it would not copy to clipboard is put the protect/unprotect code in VBA. I put that code as a comment to test and it still will not copy. Lots of information but I wonder if the protection is the reason for the copy not to work anymore as it is the only thing I changed.

 

[duggie33]

Another way to copy a cell's text to the Windows clipboard can be found in this link...

Copy from Excel and Paste in external app?

Good morning! Here's today's issue: I'm copying from a cell in Excel to another app. I'm getting a trailing carriage return when I paste in Notepad, Word, and Adobe Acrobat. Result: If I copy the text D10 and paste it in E10 I can get the value up in the Formula Bar. If I copy the...

www.mrexcel.com

I am not sure if it will solve your protection issue. For that, I usually unprotect early and protect late in the code. I do not recall having any issues like you are describing.

Hope that helps,

Doug

 

[markkuznetsov1]

Another way to copy a cell's text to the Windows clipboard can be found in this link...

Copy from Excel and Paste in external app?

Good morning! Here's today's issue: I'm copying from a cell in Excel to another app. I'm getting a trailing carriage return when I paste in Notepad, Word, and Adobe Acrobat. Result: If I copy the text D10 and paste it in E10 I can get the value up in the Formula Bar. If I copy the...

www.mrexcel.com

I am not sure if it will solve your protection issue. For that, I usually unprotect early and protect late in the code. I do not recall having any issues like you are describing.

Hope that helps,

Doug

Thank for the input Doug, ended up just finding an older copy and re-doing it...now it works with protection. Freak error I suppose in this case

 

[markkuznetsov1]

Hello, this is my first macro based workbook so please answer in laymans terms if possible. This workbook basically is button based that produces a "next number" and spits out date/time and user who clicked as well. It also should copy the produced number to clipboard to manually enter in another program. I have a separate sheet "AuthUsers" to type in users that are authorized to both, use in read/write and click the button. Everything worked flawlessly today until after I tried to protect the sheet. I first protected the auth users column with Review: Protect : Allow Edit Range (also added myself and another user to not require password to change cells). Then I protected the number generating sheet but unprotected after I realized it protects the button as well. The last thing I did before I noticed it would not copy to clipboard is put the protect/unprotect code in VBA. I put that code as a comment to test and it still will not copy. Lots of information but I wonder if the protection is the reason for the copy not to work anymore as it is the only thing I changed.

***Edit , solved...copy to clipboard code needs to go after the save code...that's what cancelled it