Selecting an object

Question

Hi All.I have a situation where I need to place an image on the same cell in ~100 worksheets. I would also like to assign a simple macro to the image to open PrintPreview for that worksheet.I got the looping sorted its selecting the image with the macro assigned where I am getting stuck, it’s somewhere in defining the object I am having problems with.Any ideas please?Many thanks.Jon

detlef_lewin · Answer

JonnieMorgan&nbsp;Why not making it complicated and just put the PrintPreview icon in the QAT?&nbsp;

jonniemorgan · Answer

Thanks but whats the QAT?

jonniemorgan · Answer

Sorry just realised, my bad. Because I want the display to only show the invoice, no menus or toolbars.

detlef_lewin · Answer

My version of Excel shows the menu and the QAT during PrintPreview. Did you program another version of PrintPreview?

jonniemorgan · Answer

No, my version is not showing either of those, just normal PP with usual options.

Forum Discussion

Selecting an object

Share

Resources