Locking hiding cells that contain external data

[alexg]

I have set up excel to import data from an access database - I then need to perform a lookup on this data without the end user actually seeing the table of data. But the only problem is that the data is constantly changing and needing to be refresh - but when you hide the coloums and protect the sheet the data cant be refreshed. Any ideas?

 

[MarkAndrews]

Write a macro which unprotects the sheet, refreshes & then protects again

Mark