I have code, which when a cell is doubleclicked, a hidden worksheet beomes visible. In Excel 32bit, this works fine, but I now have a customer with Excel 64bit and when he does this, it goes to the newly visibile worksheet instead of staying on the one the selection was made on. What do I need to do so this works the same as it does in Excel 32bit? Tia.
What's the code?
Entia non sunt multiplicanda sine necessitate
Originally Posted by shg
Please Login or Register to view this content.
Dunno why that moves the selection (and don't have 64-bit installed to try), but you could certainly add
... after making the sheet visible.Please Login or Register to view this content.
Thanks shg. Is the code you provided more efficient than
?Please Login or Register to view this content.
Not more or less, but I think it's clearer as to intent.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks