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 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.
Last edited by AliGW; 03-21-2020 at 02:06 AM.
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
I started learning VBA because I was lazy ...
Still developing.... being more lazy...
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).
Last edited by beenanu999; 03-21-2020 at 03:31 AM.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks