I would like to pass program control from a VBA macro to a user on a
particular sheet, let the user do whatever, then return control to VBA and
pick up where I left off with all my VBA variables/pointers intact.

I think the answer is "Design it a different way", but I thought I'd ask
since I would prefer to the let the user process the data in the already
complex spreadsheet, instead of having to dupe all the formulas in vba.


thanks,

tim