How to run Macro from another sheet

I have a macro in Sheet3 (Connections), Which is updating pivot table in protected sheet.
I want to run this macro from Sheet4 (Home) and hide Sheet3(connections).

Please Login or Register  to view this content.

I just answered this in another thread:
place the same code in a module instead of the sheetcode. Code placed into a module is available to the whole workbook
Cheers
Erwin

Erwin, Thanks for your reply,
I moved codes to module, still its not updating in Sheet3 (ie: I have an update button in sheet4 and Pivot tables in Sheet3, When I click update button in Sheet4 macro should run in Sheet3 and update pivot tables).

So, as quoted in the yellow banner above this thread, please upload a non-personalised sample of your worksheet.
Than I, or anybody can look into your problem.
Cheers
Erwin