Forum Discussion

Copper Contributor

Jul 15, 2023

Selecting an object

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...

Macros and VBA

Detlef_Lewin

Silver Contributor

Jul 15, 2023

JonnieMorgan

Why not making it complicated and just put the PrintPreview icon in the QAT?

JonnieMorgan

Copper Contributor

Jul 15, 2023

Thanks but whats the QAT?

JonnieMorgan
Copper Contributor
Jul 15, 2023
Sorry just realised, my bad. Because I want the display to only show the invoice, no menus or toolbars.
- Detlef_Lewin
  Silver Contributor
  Jul 15, 2023
  My version of Excel shows the menu and the QAT during PrintPreview. Did you program another version of PrintPreview?
  - JonnieMorgan
    Copper Contributor
    Jul 15, 2023
    No, my version is not showing either of those, just normal PP with usual options.