Workbook_Open() Not working

[Quasis]

Hi guys,

I know you can help, I'm not skilled at VBA and I have a very simple request. Currently the following code works in the sheet module:

Please Login or Register  to view this content.

However, it won't work when I open the workbook. I believe this is because I don't have it in the "This Workbook" module. However, if I do paste this in, how would it know what sheet to use? Furthermore, I already have 1 other VBA code in the "This Workbook" module. How can I use both?

Thanks!

[skywriter]

What sheet do you want it to use?
Share the other code in the ThisWorkbook module.

[Richard Buttrey]

Hi,
Put this code either before or after the current code.

If the other VBA code also operates on the same sheet on which you want this code to operate then the simplest solution would be to make the first instruction in the workbook open event procedure.

Please Login or Register  to view this content.

If the two code blocks operate on different sheets then either use the .Activate instruction to activate the relevant sheet before its code runs, or preferably since it's a better practice fully qualify the Range("B" & r)...instruction with the sheet name. the easiest way to do this is to top and tail yourf code with a 'WITH' and 'END WITH' instruction. e.g

Please Login or Register  to view this content.