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

ActiveWorkbook.CustomViews("CEO View").Show

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.