PDA

View Full Version : Solved: Forcing User To Enable Macros



zoom38
11-27-2010, 02:33 PM
Regarding article

http://vbaexpress.com/kb/getarticle.php?kb_id=578
or
http://vbaexpress.com/kb/getarticle.php?kb_id=379

is there a way to open the file to the sheet that was active when it was closed?

I can't figure it out and am thinking it may not be possible.

Any thoughts?
Thanks
Gary

Bob Phillips
11-27-2010, 02:41 PM
You would have to save the name somewhere, in a hidden name or a hidden worksheet for example.

zoom38
11-27-2010, 04:17 PM
Thanks for the quick reply XL, I didn't think of doing it that way.
Works great.
Gary