Is there an way to make this code/process more efficent ? (Alternative code/way/suggestion

Hi,

First of all thanks a ton for taking your time in reading my question.

So my question is : I would like to display different tables and charts (related to that table) by just clicking buttons.

Meaning to say : If I click on a button "CEO View", then I would like to see the custom view that I set up come in the existing excel sheet.

Further Explanation : I setup an ActiveX Control (Command Button) and I used the code

Please Login or Register  to view this content.

Found the code here on this FORUM. I am still a newbie to VBA

So I want to know if there any other alternative methods/ways to do this without using VBA and I get an error message when I run the above code. Could you also help me correct the code ?


Thanks a ton for your help.

Hi,

That is not the code from the thread to which you have linked. It should read

Please Login or Register  to view this content.

If you wish to use a button rather than the menu items then you require a macro of some sort.

Select Excel's View tab, then press Custom Views and choose the view you wish to display. That is all I mean.