Geekamo
asked on
VBA - On Open Go To Worksheet "Home"
Hello Experts,
I would like my workbook to always open up to worksheet name "Home" whenever the workbook is opened. Is this possible with VBA?
Thank you in advance for your help!
~ Geekamo
I would like my workbook to always open up to worksheet name "Home" whenever the workbook is opened. Is this possible with VBA?
Thank you in advance for your help!
~ Geekamo
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Your code will work fine. That method just does not show up when using intellinsense and I just prefer when possible to use objects that do show up as they are easier to remember what I did and figure stuff out latter when I need to review my code.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
While I was waiting for an expert to respond to this question, I stumbled upon a line of code - that I placed into my already existing Workbook Open code.
Open in new window
I do prefer the code that I stumbled upon, only because it's just one line of code and it works.
But are there any benefits to using your code, over the one I found?
Let me know your thoughts.
Thanks