Latest Lists

How do you create a macro to only refresh certain sheets in an Excel workbook?

I have some external references to a Sharepoint list. There are certain sheets that have these connections that must be refreshed on the press of a button. How can I only refresh certain sheets?! Please help Can I refresh the sheets one at a time in the command...? Something like ActiveWorkbook.Refresh.Sheets("SheetA") ??? I'm creating a button to refresh specific worksheets and their connections. So it could be multiple lines of code to refresh one worksheet. Please help!

Public Comments

1. Given that the only available commands are either activeworkbook.refreshall or workbooks(index).refreshall it seems you can't directly. Reading around it looks like you can't refresh when sheets are protected. It may be a lot of hassle, but I suppose you could have each sheet linked to a separate workbook and you only refresh those you want to refresh.