Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
updating links when vlookup is used and..
Hello everybody,
I created a template to administrate the hours someone spends working on a product and a total.xls with a macro that collects all the data of all the templates put in a certain location. It works great and maybe I should leave it at that, but there are some little things I like to optimize if possible. In the template I use a vlookup-formula that looks for the productid in product.xls to collect other data. Each time the user opens the template he\she is been asked if links must be updated. I like to know if its possible to anwser the question for him? I tried to put something in Private Sub Workbook_Open(), but that runs after the question. Secondly I like to know (and this is more for fun I admit) if its possible to hide\clear the whole excel-environment so the user only sees the worksheet. Thnx in advance, Polletje --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating links | Excel Discussion (Misc queries) | |||
why are my links not updating | Excel Discussion (Misc queries) | |||
Updating links | Excel Discussion (Misc queries) | |||
updating links | Excel Discussion (Misc queries) | |||
Updating links | Excel Programming |