I want to create two button in Excel sheet in which once can hid selected columns and the

[ashishpatel34]

I want to create two button in Excel sheet in which once can hid selected columns and the second one unhides the columns.

I just want the code to perform this action. For eg

I am using a excel sheet in which I feed data daily. I need to hide columns G to N frequently and also unhide them. I have to select the cels and then choose hide or unhide. I want to develope such a system which just performs my action without selecting or selectin unhiding of cells.

If there is any way please update. I will be very greatful to you.

Regards
Ashish

[Spencer101]

Hi Ashish,

You could use the "record macro" function built in to Excel to record the hiding and unhiding of columns (separately) and then associate the two macros with two buttons.

That way you wont have to write any code at all as Excel will do it all for you.

Hope that helps.

S.

[john55]

maybe this

Please Login or Register  to view this content.

[savia405]

I know only one option to hide and unhide a column right c;lick on the selected column and choose the hide and un hide opinion.