Refresh data in Protected worksheet

K

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
 
I

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
 
K

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?
 
Top