karolina1406
Board Regular
- Joined
- Apr 18, 2016
- Messages
- 110
- Office Version
- 365
- Platform
- Windows
hi, can someone help with vba code for refreshing query (called "Query1) on protected with a password "123" sheet called "Summary"?
thank you for your help. Recorded macro was actually very easy and it almost worked It updated the query table with all the "added" values however, when any value was removed from the source table - it didn't update Query table with this removal. the code was as belowmaybe easiest with the macro recorder. is that familiar? unprotect sheet, refresh query, re-protect sheet
start macro recorder with ALT-T-M-R
and finish maybe (may vary by version & I don't know about 365) with pressing rectangle at far LHS of status bar
I don't know the way 365 refers to query table objects either
if you want to refine the recorded code, please post it back to the forum. cheers
ActiveSheet.Unprotect
ActiveWorkbook.RefreshAll