Hiding Columns / Sheet selection

Hello,

I have a simple code that hides / shows a selection of columns.
Now i have it attached to some controls located in a different sheet (i.e "Tables"), when i click the buttons it does exactly what i need it to except...

It switches to the sheet ("Summary") where the cells are.

I need the screen to stay put and not switch can anybody help me out?, the reason being i have about 15 charts i want to copy the controls too without having to customize each macro to switch back to the sheet where the controls are located?

Please Login or Register  to view this content.

Thank you!