Running a Macro on Startup

[Nomas]

Hi,

I have the following macros that I basically want to run upon opening a file and to copy an existing sheet and renaming it. If I run the duplicate macro it works fine, just doesnt work at startup.

Private Sub Workbook_Open()

Call Duplicate_Item_List

MsgBox "Item List Duplicated", vbInformation, "Item Tool"

End Sub


Sub Duplicate_Item_List()
'
' Duplicate_Item_List Macro
'
'
Sheets("Item List").Select
Sheets("Item List").Copy Before:=Sheets(7)
Sheets("Item List (2)").Select
Sheets("Item List (2)").Name = "Item List Checksheet"
Range("A1").Select
Sheets("Item List").Select
Range("A1").Select
End Sub

I'm not sure where to go. I appreciate any help in advance

 

[Smitty]

Welcome to the Board!

Where did you put the Open event code? It should be in the ThisWorkbook module.

 

[Nomas]

Thanks, Im new to macros but quickly liking them. It is created in Module 2. Not sure how to get it to ThisWorkbook or what that is

 

[Nomas]

Figured it out, thanks a ton!

 

[BarCodeWiz]

To get to ThisWorkbook

1. Hit Alt+F11
2. Expand VBAProject (Book1) or whatever the name of your workbooks is.
3. Double click on ThisWorkbook under "Microsoft Excel Objects"
4. Copy the text into the right side of the screen