Hi LokLuk,
thanks for your reply - got me started with getting this sorted! I've made a few alterations to your code and it currently stands like this:
This saves the pdf with the file name referencing cell G3.
However, i'm still in need of some help! The entire 7 pages covers rows 1-172 which i have set in the zone impression. When i select, for example, check box 1, 3, 6 the corresponding rows are un-hidden and the user will be viewing page 1,2,4 and 7. When i then use the VBA above, it creates the full 7 page doc - filling in the visible pages with blank ones! Is there any way which i can change the A1:N172 to be dynamic, ie. only the pages which are visible to the user will be saved to pdf? do i need a variable print area linked to the checkboxes? can you create a pdf from different ranges on an excel doc?
Thanks again for all your help!
Bookmarks