200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hello,
I am getting such a kick out of the Turkey Takeover code. I have most of it working except when I open my own workbook where I copied the code, the TurkeyManager does not run. Perhaps the error is related to the Private Sub Workbook_SheetActivate ? I renamed my module where all of the public routines are to "Elf". Maybe that's the problem?
Hi again Susan.
In the attached modified file, the module is renamed Elf (as you said) but I added this simple event macro:
Private Sub Workbook_Open()
' switch sheets on opening so the Turkeys start to run on second sheet
Sheet1.Activate
Sheet2.Activate
End SubThis quickly switches sheets when the file is opened and the turkeys start to run straightway.
You can just copy that code to the ThisWorkbook section of your file (in VB Project Explorer) The tutorial shows how to add extra turkeys (e.g. to the Empty sheet) I think.
Hope this is does what you want. If so, please remember to mark this Answer as Selected.