11826A-test.xlsm
In the attached I have a button on the picking log tab labeled start new batch. I want to call the following code when button is clicked. How would I insert this?
HTML Code:
11826A-test.xlsm
In the attached I have a button on the picking log tab labeled start new batch. I want to call the following code when button is clicked. How would I insert this?
HTML Code:
If your workbook runs a Workbook Open event handler, it's always a good idea to make people aware of it ... just in case.
And, if you want help with VBA inside a password protected VBA Project ...
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
my apologies, the password is Traveler 11826A-test.xlsm
If you are calling Private sub within a same code module, just add sub name anywhere you want.
e.g
Otherwise you need to qualify its parent with application.Run method.Please Login or Register to view this content.
e.g
Please Login or Register to view this content.
Remove the "Private" key word from the module. Then right click on the button and select Assign macro and choose the module from the list.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks