Dear All,

i am building a kind of application.
there is around 10 charts in a worksheet, each chart is a different page.
i would like to create on each page a CheckBox and user can select or unselect the page with chart.

but i am having to find a code to deselect specific printing area.

or maybe should i rise a different question, is it possible at all?

If CheckBox1.value = True then
ActiveSheet.PageSetup.PrintArea = "$A$7:$H$30"
Else
If CkeckBox1.value = False then
here a code to deselect the printing araa.
end if