Private Sub Workbook_BeforePrint(Cancel As Boolean) Range Issue (2007)

Good day,
I have set up in my "ThisWorkbook" the following code:

Please Login or Register  to view this content.

This code seems to work when it want's to. In my Sheets("Control").Range("A2").Value I have a list of name that when I double click a userform with a combobox selection is introduced. But when I add another user into to my Sheets("Control").Range("A2") and then print...it will take the previous name that was in there...

What Am I doing wrong here?

Nothing obvious. Does your other code disable events anywhere?

I have this in my Userform:

Please Login or Register  to view this content.

And I have this in another userform for the name selection:

How does A2 get populated?

By either entering by hand or double clicking the cell A2:

Please Login or Register  to view this content.

I mean when I look at the Print Preview it will make it the value in A2 from my Control Sheet but when it prints it will still mentioned the previous user...

There's nothing in any of your code that mentions A2. Is it linked to the combobox control directly?

No it as follows:

The user will sometime change, therefore I have a Control Sheet that, in A2 either the user Double-Clicks or add the user by Hand, if d-c, then a userform will pop up with the following:

Please Login or Register  to view this content.

Therefore adding the selected name, from the userform, in the active cell, ActiveCell is A2.

I can't see anything wrong with the code so without the workbook I'm afraid I can't comment further.

Here is an example wkb

Print.xlsm

You need to select the Pre-Solicitation Sheet and click on the Print Cmd_Button "Print Options" and select the "Print All Sheets". If you print a name will be in the top left, that doesn't even match the name selected in sheet Control.

Ah yes, I'd forgotten about this nice new feature. If you use the Backstage Print preview screen, the BeforePrint event won't run. If you print directly, or use the old full screen print preview, it does run. You'll need to run the page setup code from the code that updates A2, I think.

Thank you for the heads up...

I have changed the sheets("Control") code to add:

Please Login or Register  to view this content.

Now it works

Thank you for the tip...