Multiple Macro's within 1 workbook

[DonnaA]

Hi All,

I'm really new to using Macro's (so this may be a pretty simple question). I've added a Macro to our Work Order that will increase the WO # number by 1 every time it opens and it is working well. But within the same Workbook on a different Worksheet there's a Delivery slip that has a numerical sequence I would like to do the same but I can't seem to get that one to work. Here is what I've written in the Visual Basic showing what I've entered to create the Macro (see pic below). Can anyone help I would really appreciate it.

 

[Skyybot]

Notice how the top Window in your picture is "Workbook" and the second Window is "Gerneral"? Try putting the the line in the second window below the line in the first Window. Saving. And testing.

Private Sub Workbook_Open()
Range("G5").Value = Range("G5").Value +1
Range("H38").Value = Range("H38").Value +1
End Sub

 

[DonnaA]

Notice how the top Window in your picture is "Workbook" and the second Window is "Gerneral"? Try putting the the line in the second window below the line in the first Window. Saving. And testing.

Private Sub Workbook_Open()
Range("G5").Value = Range("G5").Value +1
Range("H38").Value = Range("H38").Value +1
End Sub

Thank you so much this worked
Not sure why I thought I would need 2 macro's, it didn't occur to me to combine them
Appreciate the help !!!!

 

[Skyybot]

Thank you so much this worked
Not sure why I thought I would need 2 macro's, it didn't occur to me to combine them
Appreciate the help !!!!

Np. Happy to help.