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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.