I know want I want but I don’t know what it is called. I’m guessing promote and demote. That sort of explains what I’m after but there is probably a better way
Anyway, on my spreadsheet I’ll have a data validation cell. The values are “With” and “Without”
If I select “With” then the entire spreadsheet is available for printing. If I select “Without” then it will hide columns 41 to 164 and they won’t be available for printing
Therefore
If a1 = “WITH” DO NOTHING and if column 41 – 164 are hidden, unhide them
IF a1 = “WITHOUT” hide from display and printer columns 41 - 164
Bookmarks