Hi everyone,
Still a novice at VBA lol, I have the below code, could someone tell me how i make it so that the first 2 macro's run on workbook open in order of its appeareance in the code below? so far on workbook open only 1st macro runs but not the 2nd and i am assuming its because o i have an end sub in the 1st macro.
Please Login or Register to view this content.
Only have in the workbook Module the following and put the other 2 codes in another sub.
Then you can put something like and do them in order.
Please Login or Register to view this content.
!If all your troubles are solved, then so is the thread. Show this by marking it so using thread tools at the top of the page.
If I helped do this, then please show your appreciation by awarding rep points.
<------ Button for that is over there
Hello,
call the PasswordProtect routine (and any other sub) from within the Worksheet_Open routine:
cheers, teylynPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks