Prevent user from printing chart alone, without the rest of the worksheet

[Pseudo312]

My workbook has a tab for a data entry form, and then another tab with a dynamic chart and some statistics. I'm having an issue where the user enters the data, clicks on a cell, and it prints properly. But if they click on the chart and then hit print, the only thing that prints is the chart, minus everything else on that page. I'm hoping there is some way to force the entire page to print (much easier to build something like this into the workbook instead of trying to train everyone that uses it). I tried setting a print area but that doesn't seem to do the trick.

Thanks much,
Pseudo

[newdoverman]

There should be a way using VBA to set a print area and allow only that area to be printed.

With any luck, a person conversant in VBA will be able to help you with this.

[aydeegee]

Hi Pseudo312

Welcome to the forum.

Could your users be taught to click on a shape that says something like "Print" rather than their usual way of printing?

If so, you could select the chart, record a macro that selects a cell, then prints.

You can then insert a shape (any shape will do) and attach this macro to it.

You will need to save the workbook as aaaaa.xlsm rather than aaaaa.xlsx and ensure that all computers that will be running this macro have the appropriate security level.

Let me know if you need anything explaining.

Regards
Alastair