Creating a Macro that hides part of your spreadsheet

[RobMarshall]

What Im trying to do is create a Macro assigned to a button that would allow the person looking at it to only see a particular part:

eg:

This might be the existing:

A B C D E F

1 Title Name Number Attendance Result Total


On pressing the button, the person would see the following:

B D E

1 Name Attendance Result


Thanks!

Rob

[AlvaroSiza]

Assuming you want one button to hide the data and another to show it (or you will have to manually highlight the columns and right-click -> unhide...

To hide...

Please Login or Register  to view this content.

Insert a button from the control toolbox. Right-Click -> View Properties...rename the button ("caption") and format it how you want it. Now right-click the button and choose "View Code". Type HideColumns where the cursor is active. This will assign the above code to that button.

To re-show the columns

Please Login or Register  to view this content.

Again...go through same steps as before as to creating the button and formating. After "View Code" the name will be ShowColumns.

Use your macro recorder. Despite some unnecessary code, its a great way to learn. And I am sure that there is a one-line code to do what you wanted, but this will definately do the trick. See attached for code and reference. Hope this helps.

[protonLeah]

Try these:

Please Login or Register  to view this content.

[royUK]

Consider Custom Views from the View menu. You can automate switching views with VBA.

[RobMarshall]

Thanks a lot guys,

that worked a trick!

Cheers,

Rob