Hi,

Macros are not my strong point, but id like to set up an auto print option on a report ive built
however the print option would only be relevant to the specific months tab
e.g Aug (tab name)

I know the code to name a specific sheet is Sheet ( "aug").select

but I don't want to change the macro every month so was hoping to drive the macro from a cell reference which I would have set as a list

is it possible to have the "aug" as a cell reference ? so it would switch print options driven by the tab name change

sorry if ive not explained this very well