Highlight Active Row macro, and Bold the Active Cell

[StudentTeacher]

Hi Programmers,
I'd like to not only highlight the active row, but also highlight the active cell with bold formatting. I'm using the code from this thread: Highlight Active Row macro error; http://www.excelforum.com/excel-prog...ro-error.html; but don't know how to adapt it.
Also, if cells happen to already be highlighted or formatted bold, the code should not interfere with this prior formatting.
Is this possible?
Lastly, the worksheet should reset to the prior formatting.

Thanks a bunch.

Please Login or Register  to view this content.

[antoka05]

You could try with this code:

Please Login or Register  to view this content.

Regards,
Antonio

[StudentTeacher]

Hi Antonio,

Thanks, that works and looks good.
I'm still having difficulty though resetting it prior to close. For instance, the workbook is saving the yellow highlighting and bold formatting--when the workbook opens again, the row that was last selected has the yellow and bold formatting. How would be the most efficient way of turning this off prior to a save?

Thanks.

[rollis13]

Have a try with this attached file (not much testing done).
Added BeforeClose, BeforeSave and a clearing macro.


PS. posted in the wrong thread, shoud have been here: http://www.excelforum.com/excel-prog...html?p=3122457