Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Need help creating VBA code to do the following. Thanks in advance. To help choose icons (and the corresponding imageMSO value for the RibbonX code)

Need help creating VBA code to do the following. Thanks in advance.

image text in transcribed

image text in transcribed

image text in transcribed

To help choose icons (and the corresponding imageMSO value for the RibbonX code) use the Office 2007 Icon Gallery which is an Excel file that contains a custom tab displaying more than 3000 icons that can be used in your applications. Note: There is an Office 2010 Icon Gallery, but it is formatted into a custom Word Document and is less useful. There would be few icons that had changed that you probably wouldn't need anyway Note: When viewed in Office 2013, the icon styling, if different, for the new version would apply, Finding An Icon Download the Office2007 Icon Gallery: Run the .EXE file and unzip the files as instructed. By defal it creates a folder on the root of the c: named 2007 Office System Developer Resources Open the file and display the Developer tab to see the icon gallery Office2007IconsGallery.xlsm Microsoft Excel Developer Map Properties Import Expansion Packs oe Export Refresh Data Gallery 4 . allery 7 Gallery 5Gallery 8 Gallery 6 Gallery 2 Source PanelGllery3 Modify Gallery 9 XML Office lcons Look for a suitable icon for display a form that calculates average, and take note of it. Clicking an icon displays the name and two views of the icon, large and smal. Write it down if necessary and make sure to maintain proper capitalization as the names are case sensitive. Alternatively you can use a name such as HappyFace, or SmartArtAddBullet. This is the name you place in the ribbon later. To help choose icons (and the corresponding imageMSO value for the RibbonX code) use the Office 2007 Icon Gallery which is an Excel file that contains a custom tab displaying more than 3000 icons that can be used in your applications. Note: There is an Office 2010 Icon Gallery, but it is formatted into a custom Word Document and is less useful. There would be few icons that had changed that you probably wouldn't need anyway Note: When viewed in Office 2013, the icon styling, if different, for the new version would apply, Finding An Icon Download the Office2007 Icon Gallery: Run the .EXE file and unzip the files as instructed. By defal it creates a folder on the root of the c: named 2007 Office System Developer Resources Open the file and display the Developer tab to see the icon gallery Office2007IconsGallery.xlsm Microsoft Excel Developer Map Properties Import Expansion Packs oe Export Refresh Data Gallery 4 . allery 7 Gallery 5Gallery 8 Gallery 6 Gallery 2 Source PanelGllery3 Modify Gallery 9 XML Office lcons Look for a suitable icon for display a form that calculates average, and take note of it. Clicking an icon displays the name and two views of the icon, large and smal. Write it down if necessary and make sure to maintain proper capitalization as the names are case sensitive. Alternatively you can use a name such as HappyFace, or SmartArtAddBullet. This is the name you place in the ribbon later

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions