Hi,
Thank you very much in advance for your help.
I have attached a simplified version of the xls I am using. On the attached xls there are two tabs. The first tab (BUYS) has linked pictures of cells on the second tab (Warehousing).
I would like some code which would display the pictures only when the corresponding cells in Column F have a number in it. (This number could be anything)
e.g. If cell F4 has a number in it show Picture 1
If cells F4 and F5 have a number in them show Picture 1 and 2
My full xls (not attached) has another tab called SELLS. These two tabs (BUYS and SELLS) have 15 pictures each (1 for each row 4:18).
Ideally an exception would be written into the code so that if the xls was named "yymmdd Asian Executions" or "yymmdd Europe Executions" none of the pictures would show up.
I hope I have been clear but it's very difficult to be objective so please let me know if you need any more information.
Thanks again,
Emmy