Unhide or insert columns

[S Shipley]

I have a template that our project office uses for all projects and have
written a macro that brings up a control with a list of all columns that
let's the user check the columns they want to hide. When they click on the
button Hide Columns the columns selected are hidden.

I would like to use this same control in reverse to re-insert the columns in
the same position that they were in the original template. I am at a loss
for how to accomplish this - any help will be greatly appreciated.

 

[Jan De Messemaeker]

Hi,

Keep the original table as an object and re-apply it
HTH

 

[S Shipley]

Jan,

Thanks for the response. I did another search on the forum and found the
thread "Add column to actual view" where you answered T. Klaus and that was
exactly what I was looking for.

Thanks for your help