MACRO CODE RIBBON MENU IN EXCEL
Provide maximum results and satisfaction to visitors is our priority. Take a few minutes to understand this article, because this will be very brief and detailed.
To run the Ribbon Menu In Excel, you need to put the Macro Code in the Excel VBA window. For more details, please follow the steps below.
1. Download the sample file
2. Open the file
3. Try to click "Ribbon Menu" available. Then there is a notice like the picture below. ("Cannot RUN The Macro "Generaldata". The Macro May Not Be Available In This Workbook or All Macros May Be Disabled")
2. Open the file
3. Try to click "Ribbon Menu" available. Then there is a notice like the picture below. ("Cannot RUN The Macro "Generaldata". The Macro May Not Be Available In This Workbook or All Macros May Be Disabled")
Why did the notice appear ?
As contained in the notice above. That you are prompted to enter the Macro Code.
Follow the steps below !
1. Open the Visual Basic for Application (VBA) window. Press "Alt + F11"
2. Make 1 module
3. Copy and Paste this kode
Sub Generaldata(Control As IRibbonControl)
Sheets("Sheet2").Range("B2") = "This Page is General Data"
Sheets("Sheet2").Select
End Sub
Sub Datamember(Control As IRibbonControl)
Sheets("Sheet3").Range("B2") = "This Page is Data Member"
Sheets("Sheet3").Select
End Sub
Sub Printthecard(Control As IRibbonControl)
Sheets("Sheet1").Range("B2") = "To enable the above button, you can visit our article about, Macro Code For Ribbon Menu In Excel"
Sheets("Sheet1").Select
End Sub
Sheets("Sheet2").Range("B2") = "This Page is General Data"
Sheets("Sheet2").Select
End Sub
Sub Datamember(Control As IRibbonControl)
Sheets("Sheet3").Range("B2") = "This Page is Data Member"
Sheets("Sheet3").Select
End Sub
Sub Printthecard(Control As IRibbonControl)
Sheets("Sheet1").Range("B2") = "To enable the above button, you can visit our article about, Macro Code For Ribbon Menu In Excel"
Sheets("Sheet1").Select
End Sub
5. Try pressing the ribbon menu button above
6. If the above notifications are not present, then the Code macros you entered are correct
Read The Following Summary !
1. You must apply the Macro Code in the VBA window
2. Sub Generaldata(Control As IRibbonControl)
1. You must apply the Macro Code in the VBA window
2. Sub Generaldata(Control As IRibbonControl)
OUR PRIORITY
We are very concerned about Results and Satisfaction to Visitors, So, in addition to the above article, We also attach the example file below.
Download File
We are very concerned about Results and Satisfaction to Visitors, So, in addition to the above article, We also attach the example file below.
Download File
"we always try to provide the best and original articles for you"
Copyright@2018
Post a Comment for "MACRO CODE RIBBON MENU IN EXCEL"