I have a column for print buttons that print the data of a particular cell in that row. Eg print button in K1 prints J1 cell content. Pls is there a way I can make my print button to only appear when there is data in a particular cell eg B1 on the row so that I do not need to copy all the buttons throughout the length of the worksheet as it will make it buggy and probably slow it down. Another scenario is for a print button to be in another cell like L4 but displayed in the needed cell in column K when data is entered in corresponding cell in another column like say B ...ie when B1 is not blank, print button displays on K1 to print content of J1. If B1 is blank, no button for print available. Thanks.