Update remote worksheets

S

ssGuru

Periodically I need to update lookup lists in remote client
workbooks. I have a project where all the VLOOKUP lists and tables I
use for calculations and such are in a single hidden, passworded sheet
named LISTS in the templates workbooks my clients use at their site.
Currently I have to get their workbooks, unlock, update the sheet
locally and return their templates one at a time.

Any ideas of how to go about creating and sending them a update
routine or form with a button that would automatically replace their
existing password locked and hidden LISTS worksheet with a new one?

I had considered creating an UPDATE worksheet form I could email to
them with a button to run "run" code that would copy the new hidden
and locked LISTS worksheet from the UPDATE worksheet to their
template.

Looking for your ideas about the process or any links that might help
get met started correctly,
Dennis
 
G

Guest

I had considered creating an UPDATE worksheet form I could email to
them with a button to run "run" code that would copy the new hidden
and locked LISTS worksheet from the UPDATE worksheet to their
template.

sounds doable.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro to return value of worksheets 2
Excel crashes and restarts when accessing newly created worksheet 2
VBA to compare workbooks 2
Include Dropdowns and Checkboxes in Worksheet Change event 1
COPY MODULE MACRO WITH WORKSHEET TO OTHER WORKBOOKS 2
Data Validation blanks 5
Create multiple worksheets 7
update validation when change source 2

Top