Excel VBA Events #7 Workbook Events - Run code when you print, save, open or close workbooks etc

WORKBOOK EVENTS!
With these, you can set off your code whenever the workbook is opened, or when someone clicks the "Print" or "Save" button, when you close the workbook, create a new sheet, activate 'any' sheet, select 'any' cell in the workbook, and the list goes ON AND ON!!!
Check it out. This is powerful.

Fantastic Developer Tools:

[ExcelVbaIsFun]

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

[ExcelVbaIsFun]

It's my pleasure to help Rick. Thanks for watching! Dan

[ExcelVbaIsFun]

Wow, very interesting, I'll have to try that out sometime. Thanks for your input and kind comments!

[ExcelenciaPersonalTV]

Hi. How could I make excel only print by a macro and avoid Ctrl + p or printing in several sheets??

[cliffordhammond]

Hi Dan. Not sure if you resolved the WindowResize, looking at the video you resized the whole program, the script works if you try to resize the worksheet with in excel.
Sorry if you already got an answer on this, I didn't see anything on the thread above. Thank you for all the great viseos, you are a fantastic teacher of the vba series

[ExcelVbaIsFun]

hmmm. Not sure if I understand. What thing are you trying to use to trigger an event. Most any activex or form object, image, part of a userform - will trigger. As for worksheet or wb events, i think you're pretty limited to the options in the worksheet events/wb events listed in the vb editor. I could be wrong. Thanks! Daniel

[rztv]

hi im making a data entry in excel which includes multiple user forms in vba, my question is? can it be used by ten users at the same time using data entry userforms example 1 user is for data encoding 2nd user is for encoding other details like costumer orders and the 3rd users is ecoding for the tracking numbers of our product from the spreadsheets
using also userform, please help me thank you.

[musicspinner]

Can you do Application events? i.e. Any spreadsheet opened in Excel that meets certain conditions (maybe has tabs with specific names that code will recognize) will have event dependent code.

[musicspinner]

Also - is it possible to have VBA module run a create Worksheet code for worksheets that the module creates?

ie. Macro to create worksheet event code?

[juakaliatl]

how to search text data in two worksheets and copy/paste to the third one sheets with vba

[vegasvato]

I would like to see how to make my whole Excel application work book to be invisible until I enter a user id and password into a dialog box on application start up...

[FamilyLifeComC]

you have had a lot of learning, but you are too fast, can catch it...does not explain the basic of saving code.