VBA working with conditional formatting

I have this code working in an .xls file but it won't work in another whether it is .xls or .xlsm
I have another formula in conditional formatting working with this macro to highlight the row/column of the active cell.
I can do an F9 recalculate to make the formatting work, can't figure out how to make it auto calculate
like it does in the other spreadsheet.

Also, what is the signifance of the General vs. workbook and worksheet_selectionchange vs. (declarations) and open

Thanks,

Private Sub Workbook_Open()

End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = True
End Sub

macro won't workDAILY REFERENCE SHEET.xlsm
macro worksExpress Chipping Invoice Reconciliation.xls

I recently moved from XP to Windows 7 for background

When I opened your version it worked as it should.
I then saved it and reopened it and it won't work until I press F9 to recalculate manually.
What happens in the save/reopen that will disable the automatic recalculate that worked previously.
What in the VBA performs the F9 function automatically is another way of asking the question I guess.
Thanks

Checked that first thing, set for automatic under Excel Options

No Joy, the macro only updates manually for the formatting.
The only thing I changed is a new PC, moved from XP to Windows 7.

Perhaps if I restate my problem. The VBA coding used to work fine on my XP system. The coding worked the first time I opened your file, once saved on the Windows 7 system it will not work when opened again. If I open it from your link in this thread the coding no longer works as it did the first time.
All instances of formula recalculation is set to automatic.
The conditional formatting changes when F9 is pressed in all instances.

Two questions, what in the VBA recalculates the worksheet to invoke the conditional formatting when the cell location is changed; and, what is so different in Windows 7 interacting with Excel 2007 than XP to make this glitch happen and how to fix it?

Which worksheet of which workbook are you referring to the H3 cell?

Markstro-In the workbook you said worked; specifically the conditional formatting part, it had the following vba coding on the specific sheet you said worked: (This is the same coding I placed on the sheet you said wasn't working)

Please Login or Register  to view this content.

It is here where the cell "H3" is referenced. I hope that clarifies your question.

The code with H3 in it is not related to my problem, unless it may be causing the problem.
I am thinking the platform from XP to W7 may have a bearing on this. Anything on that line of thought?????

The worksheet_selectionChange code is the one I can't figure out.
This is an integral part of how I navigate my spreadsheets and others who use them as well.

The H3 code is for searching the sheet without hitting Ctrl F to find a particular truck number I am searching for, I may need to unbug that as well.

Because of the large spreadsheets we use in my company, I found out how to highlight the column & row, then make it constantly update as you moved the cursors.
It worked like a charm for everyone who need to enter data or view it, makes ensuring you're looking at the correct header row and column is all.
This problem is very similar to your test sheets in the previous message, I discovered the same behavior early on when I forgot to copy the code to a new sheet I had already
completed the CF on. Once I insert the code, no problems until recently. I make the CF pertain to the entire range I need to ID row/column's.
How does the code constantly update the CF when I move the cursor to a new cell????

Ok guys, thanks for the support.
Just trying to digest what you're all telling me, Maybe it's time to move up the knowledge level on how to use VBA.
I'll post an update soon as I can.

Express Chipping Invoice Reconciliation.xlsm
watersev, I've attached my file with your code inserted, still no joy. F9 works though.
What am I missing in my description of my system or situation in general.
I spent enough time debuggig this VBA/CF a couple of years ago and thought I would never have
to go through again.

One more clue that may help, after enter new data in a cell, hit return and the CF kicks in.
I am still not sure just what part of the code does that, the Application.ScreenUpdating = true??????

the following screenshot is taken from Excel 2007, your file from post #21

Please do the following code: open posted file, run code

Please Login or Register  to view this content.

Save and close file. Open it up. It should work exactly as on the screenshot attached without F9 pressing.

@MARKSTRO

The trick is done by: application.screenupdating =1 sitting in This Workbook module level in Workbook_SheetSelectionChange. It forces CF to be calculated though a cell is selected only.

For the events to be happening you need to EnableEvents, see previous post.

I'll get on this, thanks.
Then how did it work as it was all this time???

as soos as you (or some code) set EnableEvents to False - turn off, it is set until revert its value to true

vba screen shot 1-12-12.jpeg
Please see attached image
Is this what the VBA is supposed to look like.
If so, no joy.
Thanks,

OOps, wrong screen shot, the correct one has the code you posted in post # 18

Message Box testing
1.Close and save any open workbooks, and then create a new workbook.
2.Start the Visual Basic Editor (press ALT+F11).
3.If the Project Explorer window is not visible, click Project Explorer on the View menu.
4.In the Project Explorer window, double-click Sheet1 to open the Code window for Sheet1.
5.In the Code window for Sheet1, type or paste the following code for the SelectionChange event:

Please Login or Register  to view this content.

6.Switch to Microsoft Excel (ALT+F11).
7.Select any cell on Sheet1.

Does the message box show up with cell address?

If no, please open attachment file, run code "EnableEvents". How to Run a code:

1.If the Developer tab is not available, do the following to display it:
- click the Microsoft Office Button , and then click Excel Options.
- in the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.
2.To set the security level temporarily to enable all macros, do the following:
- on the Developer tab, in the Code group, click Macro Security.
- in the Macro Settings category, under Macro Settings, click Enable all macros (not recommended, potentially dangerous code can run), and then click OK.
3.Open attached file.
4.On the Developer tab, in the Code group, click Macros.
5.In the Macro name box, click the macro "EnableEvents".
6.Click Run.

Check Sheet("2011") of the attachment, select any cell, conditional format should work as expected.

Both sheets with differents VBA setups work now, problem may be solved, I have attached screen shots of the VBA, your version has the Sub Enable.Events code in Module 1 and mine is in the This Workbook is the only difference I can see.
your sheet screen shot 1-12-12.gifyour sheet module screen shot 1-12-12.gifmy sheet screen shot 1-12-12.gif
I hope I presented all this for you to review.
My other question remains about why this worked in my XP system without the Sub Enable.Events code, why is it needed now to work on Windows 7?

Great, makes sense. Problem Solved.
Does where the Enable.Event code is inserted; in the module or ThisWorkbook make a difference?