I am using the following code to execute code one the hyperlink is selected:
Everything works great, but when I start a new worksheet in the same workbook, I have to copy the code over to the new worksheet in VBA. Is there any way to use this code for ALL worksheets without having to copy it into every worksheet in VBA?
Please Login or Register to view this content.
Last edited by chevelle8719; 05-25-2010 at 11:36 AM.
Have you tried adding it to "ThisWorkbook" instead?
Please Login or Register to view this content.
_______________________________________________
Remember:
Read the rules!
Use code tags! Place [CODE] before the first line of code and [/CODE] after the last line of code.
Mark your post [SOLVED] if it has been answered satisfactorily.
To do this, click EDIT in your original post, click GO ADVANCED and set the PREFIX. It helps everybody!
If you are approve (or disapprove) of any members response to your problem, please click theicon underneath their post and comment. It matters.
WOW...it's funny how one little work can make a big difference.
Thanks A LOT!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks