|I'm not really sure what you are asking for. |
What is the reason to "identify the cell containing the name of the product (or the entire range) by changing the font or background color before initiating the macro"?
I don't see how "identifying" the range by changing the fill color, etc. will prevent the workbook from being rendered useless.
I guess I need some more details as to the process your users will be using and what you are expecting this "range indentification" to accomplish.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.