Code won't clear cache?

[ljubo_gr]

Hi, dear excel vba.. masters!
I have VBA code in Module1,2,3,4
In Module2:

Private Sub pASTE_SPECIAL()
    On Error GoTo AkoGRESKA
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=True
AkoGRESKA:
 Exit Sub
 End Sub

Module4:

Sub Zalijepi_LetveiTemp_Obratno_Click()
    Application.Run "pASTE_SPECIAL"
End Sub

With module4 I call private sub from module2, now I have problem, cache won't clear!?
Before module4 I run code w/o calling, directly from module2, cache than clear.
Reason for Module4: now I have a object called "PASTE VAL.&TRANSPOSE" inside excel sheet.
Thanks in advance! kind people!

 

[ljubo_gr]

Excel2013,

Maybe i need to, because of multiple opened workbooks, include: ThisWorkbook.Module2.run.pASTE_SPECIAL....., I don't know

 

[ljubo_gr]

Bump?

 

[ljubo_gr]

Here is the workbook: https://1drv.ms/x/s!ArVOOVnFRGX4hYdG26Rrp-vnqrDCmA
Now problem is, it won't paste at all!
Note: In workbook go to sheet"LETVEiTEMP", then click on blue C to copy, then go to sheet"ULAZ goriva"List1, then select cell and click object "ZALIJEPI LETVEiTEMP OBRNUTO", it won't paste!!
Any help would be appreciated Thanks!

 

[RoryA]

then go to sheet"ULAZ goriva"List1

I can't see any sheet by that name in that workbook?

 

[ljubo_gr]

It is Croatian List1 object ULAZ goriva
Thanks soooo much!

I must go to funeral, husband&wife killed in car acc..

 

[RoryA]

object ULAZ goriva

What/where is that? I note your sheet is protected which may be the problem.

I must go to funeral, husband&wife killed in car acc

I'm very sorry to hear that.

 

[ljubo_gr]

Rory, i have unlocked the workbook, sorry Rory, please.
All my life inside that wbook

 

[RoryA]

You still haven't said where the ULAZ goriva object is?

 

[ljubo_gr]

Oh, Rory,
Main sheet is "........STANJE" where is blue object shortcut named "ULAZ goriva" which sends to sheet "List1" or Sheet1 Anyhow, thank you for your precious time!

P.s. Problem is, go to sheet "Visine" eng.Hights, where is blue C, there you click that C to coppy data to clipboard, then go to sheet "List1"-shortcut object "ULAZ goriva" select H2 and then click upper object called "ZALIJEPI LETVEiTEMP OBRATNO" eng.Paste data from sheet LetveiTemp. There is problem, code won't copy data stored in clipboard.