Copy/Paste visible cells only

[theLama]

How do I set Excel to default to copy/paste only visible cells? I know how to use Edit/Goto/Special/Visible Cells Only, but want to set defaults to do this without the additional steps.
Thank you,

 

[brian.wethington]

How is this copying taking place?
Manually or by code? If by code, please post it.

Good idea John, perhaps we are missing some of the details.

 

[satyanarayan_somani]

I was expecting this to remain a problem as I said before in my last post I don't think that the issue was the same so I did some testing.

I have now tested this on 13 machines. I am not able to produce one that defaults to copying visible and not visible alike when autofiltered. I have looked in many options, I have tried to determine if there was possibly a VBA approach that would change an option like this but I am finding nothing. Therefore I am still unaware of any way to change the default. I just know someone out there knows of a way.

Does this happen to your colleague in only this specific book? Or is it absolutely every book he has?

Perhaps my previously posted code assigned to a customized toolbar button would be a temporary band-aid. It would work like the copy button only it would only copy visible cells. Just highlight the range and click the button. If your colleague is a person that perfers keyboard shortcuts to buttons you could assign a keyboard shortcut to the code.

dear all visiable cell selection is the problem of system as by default there is copy of visiable cells only as happing on My PC & laptop.