Refresh data in Protected worksheet

[Kevin T]

Does the work sheet protection work properly when
refreshing data from access.
I have the range I want to refresh Unlocked and unhidden
and the rest of the worksheet protected, but when i
refresh it tells me the worksheet is protected and I cant
refresh. Is there something I'm missing or is this a
shortcoming of worksheet protection?
KT

 

[icestationzbra]

just hazarding two guesses.

are you talking about a macro that does it? if so...

are you providing a password to unprotect before you refresh the data?

ActiveSheet.Unprotect "password"

'your refresh code would go after the above statement

 

[Kevin T]

Thanks icestationzbra for your reply but not using a macro
but updating a link from Access into an unprotected area
of the sheet. I can enter or delete information from it
but not refresh the link. Any ideas?

 

[icestationzbra]

sorry,

access is not my cuppa anything..