I need to protect my worksheet, but still be able to refresh the underlying data(table).
My worksheet is an Invoice with the body of the invoice is a table linked to underlying query. How do I refresh this data when I have locked down (protected worksheet) w/password? The only code I can find seems to unlock & Lock by storing the password within the VBA. There has to be another method.