LinkBack URL
About LinkBacks
Hello everyone.
In the attached macro is disabled:
Now the macro in the module:
Please Login or Register to view this content.
Please Login or Register to view this content.
It does not work anymore.
Help to correct.
Thanks in advance.
max
Hello everyone.
In the attached macro is disabled:
Now the macro in the module:Please Login or Register to view this content.
Please Login or Register to view this content.
It does not work anymore.
Help to correct.
Thanks in advance.
max
Hello max_max,
Try it as follow:
Regards.Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi max_max
Your Code is firing the Workbook_Sheet SelectionChange Event Code which is emptying the Clipboard.
Try this...
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hello winon.
It works the first time
the second gives error.
max
Last edited by max_max; 10-01-2016 at 04:10 PM.
Hi max_max,
Another alternative would be:
Please Login or Register to view this content.
Hello
the changes of jaslake work
the changes of winon not work
a greeting and thanks.
max
Hi max
I'll not say "Never" but it's my experience you'll not need this line in your Code...
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.Please Login or Register to view this content.
You're welcome...glad I could help.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hello.
it is possible this macro functions only on sheet 2 - sheet 3 etc .. and not in sheet1?
maxPlease Login or Register to view this content.
Thanks jaslake.
A control response to # 8?
Thanks again.
max
Hi Max
See if this works for you...
Please Login or Register to view this content.
Thanks jaslake.
the new change does not work well.
In "Foglio1" does not work
Application.CellDragAndDrop = False
In "Foglio1" works
Application.CutCopyMode = False
I attach example.
max
Hi Max
I don't understand what you're trying to accomplish.
Hello max_max,
Please add the Code below to ThisWorkbook Module:
Regards.Please Login or Register to view this content.
I hope to explain myself with google translator.
Open workbook
click Foglio2 in cell yellow
click in Foglio1
in Foglio1 not work CellDragAndDrop
in Foglio1 work CutCopyMode
I hope I explained.
max
I corrected the reply
Last edited by max_max; 10-02-2016 at 03:06 PM.
Hi Max
What do you wish to work in Foglio 1?
Drag and Drop...Yes? No?
Cut Copy...Yes? No?
Hi max_max,
Please see attached sample Workbook. Does it work for you?
Foglio2 is Password protected, without us knowing what the Password is.
Ciao
For jaslake:
in foglio1
Drag and Drop...Yes
Cut Copy...Yes
Try the revised attachment now, please.
Thanks Winon,
your modification works.
But if more than one sheet?
example:
sheet1 Drag and Drop ... Yes
sheet1 Cut Copy ... Yes
----------------------------------------------
Sheet2 Drag and Drop ... no
Sheet2 Cut Copy ... no
----------------------------------------------
Sheet3 Drag and Drop ... Yes
Sheet3 Cut Copy ... Yes
----------------------------------------------
Sheet4 Drag and Drop ... Yes
Sheet4 Cut Copy ... Yes
---------------------------------------------
Please test the attached revised sample Workbook, max_max,
It should do what you want.
Regards.
@Winon
It's yours...no sense we both bang our head against the wall.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks