Saltar al contenido
PROGRAMAR EN VBA MACROS DE EXCEL

Listado e Imagenes de Iconos que Hay en Menus Barras Ribbon de Excel #379

Para poder agregar íconos que permitan asignarles macros, se necesita saber cual es el nombre específico de cada ícono que compone las distintas barras de menús ribbon de Excel.

Desde el final del post se puede descargar el ejemplo en forma gratuita sin ninguna restricción, el código se puede adaptar a cada necesidad, Aporta por favor para sostener el sitio si está dentro de tus posibilidades, desde ya muchas gracias.

Si te estás iniciando en la operación de Excel o requieres afirmar conocimientos, recomiendo leer un excelente libro sobre Excel que te ayudará operar las planillas u hojas de cálculo, haz click acá, si quieres aprender sobre Excel, en inglés, entonces debes hacer click here. Si lo que necesitas es aprender o profundizar sobre la programación de macros con VBA este es unos de los mejores cursos on line que he visto en internet.

  
El vídeo verás la macro en acción con una explicación más detallada de su codificación y funcionamiento, recomiendo observar para una más fácil comprensión de la macro; suscribe a nuestra web desde la parte superior derecha de la página ingresando tu mail y a nuestro canal de You Tube para recibir en tu correo vídeos explicativos sobre macros interesantes, como  por ejemplo Recorre fila buscando y comparando datos de dos columnas en hojas distintasbuscar en listbox mientras escribes en textbox, como crear una factura o sale invoice y grabar guardar PDF XLS y enviar por mail, trabajando con filas, celdas, columnas, rangos y muchos ejemplos más.
  

Desde el final se puede descargar el archivo ZIP que contiene un archivo de Excel y otro de Word, desde el archivo de Excel se puede abrir el archivo de Word, es un archivo que contiene todos los nombre e íconos que contiene Excel, se verá como la imagen siguiente

⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛

Quizá sea de utilidad también

Como enviar mail desde Excel adjuntando PDF

Como enviar mail con archivo Excel y PDF mediante Outlook con Excel

Formulario de VBA para insertar datos

⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛

⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛⇛

Es preciso mencionar que el archivo de Word está un poco modificado ya que al abrir el fichero se podrá observar en el menú archivo dos menús agregados uno se llama «ImageMso 0» y «ImageMso 1» haciendo click en dichos menús se pueden ver los íconos que componen Excel.

Código que se inserta en un módulo

#If VBA7 And Win64 Then
‘Si es de 64 bits
Private Declare PtrSafe Function ShellExecute Lib «shell32.dll» Alias «ShellExecuteA» ( _
ByVal hwnd As LongPtr, ByVal lpOperation As String, ByVal lpFile As String, _
ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As LongPtr
#Else
‘Si es de 32 bits
Private Declare Function ShellExecute Lib «shell32.dll» Alias «ShellExecuteA» ( _
ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, _
ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
#End If

Sub Muestra(control As IRibbonControl)
MsgBox «suscribe a https://youtube.com/programarexcel» & Chr(10) & Chr(10) & «visita https://macrosenexcel.com»
End Sub

Sub ejecuta()
ruta = ActiveWorkbook.Path & «Office2010IconsGallery.docx»
lngErr = ShellExecute(0, «OPEN», ruta, «», «», 0)
End Sub

Si te fue de utilidad puedes INVITARME UN CAFÉ y de esta manera ayudar a seguir manteniendo la página, CLICK para descargar en ejemplo en forma gratuita.


(adsbygoogle = window.adsbygoogle || []).push({});

If this post was helpful INVITE ME A COFFEE and so help keep up the page, CLICK to download free example.

Si te gustó por favor compártelo con tus amigos
If you liked please share it with your friends

Entradas relacionadas

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Comentarios (86)

I am the proprietor of JustCBD Store label (justcbdstore.com) and I am currently trying to grow my wholesale side of business. It would be great if someone at targetdomain share some guidance 🙂 I thought that the most effective way to do this would be to reach out to vape companies and cbd stores. I was really hoping if someone could recommend a trusted site where I can buy Vape Shop Business Contact List I am already reviewing creativebeartech.com, theeliquidboutique.co.uk and wowitloveithaveit.com. On the fence which one would be the very best solution and would appreciate any support on this. Or would it be much simpler for me to scrape my own leads? Suggestions?

Responder

Spot on with this write-up, I truly believe that this web site needs much more attention. I’ll probably be returning to read through more, thanks for the advice!

Responder

Greetings! Very useful advice in this particular post! It is the little changes that produce the most significant changes. Thanks a lot for sharing!

Responder

I really love your website.. Excellent colors & theme. Did you make this web site yourself? Please reply back as I’m trying to create my very own blog and would like to learn where you got this from or what the theme is called. Thanks!

Responder

This blog was… how do I say it? Relevant!! Finally I’ve found something which helped me. Kudos!

Responder

It’s nearly impossible to find experienced people in this particular subject, but you seem like you know what you’re talking about! Thanks

Responder

Your style is unique compared to other people I have read stuff from. Thank you for posting when you have the opportunity, Guess I’ll just bookmark this blog.

Responder

bookmarked!!, I really like your site!

Responder

I really like reading a post that will make men and
women think. Also, many thanks for permitting me to comment!

Responder

Hi, this weekend is good for me, for the reason that this moment i am reading this
impressive informative article here at my home.

Responder

I have read some good stuff here. Definitely worth bookmarking
for revisiting. I wonder how so much effort you set to make such a
great informative website.

Responder

I simply want to mention I’m newbie to weblog and honestly enjoyed you’re blog site. Almost certainly I’m likely to bookmark your site . You absolutely have awesome articles. Bless you for sharing your website.

Responder

I blog often and I seriously appreciate your information. The article has truly peaked my interest. I will take a note of your site and keep checking for new details about once per week. I opted in for your Feed too.

Responder

Can I simply just say what a comfort to uncover someone who actually knows what they’re talking about online. You certainly know how to bring an issue to light and make it important. More people have to look at this and understand this side of your story. It’s surprising you aren’t more popular because you most certainly have the gift.

Responder

Way cool! Some extremely valid points! I appreciate you writing this write-up and the rest of the site is also very good.

Responder

I was extremely pleased to find this website. I want to to thank you for ones time due to this fantastic read!! I definitely enjoyed every little bit of it and i also have you saved as a favorite to look at new information on your web site.

Responder

Hi, There’s no doubt that your blog could possibly be having internet browser compatibility problems. Whenever I take a look at your website in Safari, it looks fine however, if opening in I.E., it has some overlapping issues. I merely wanted to give you a quick heads up! Aside from that, fantastic website!

Responder

world is changing

Responder

Achieving your fitness goals doesn’t need a certified personal trainer or an expensive gym memberships, it is not hard to exercise at home. It’s easy to go down a training and fitness rabbit hole, however, when you are looking for the best home exercise equipment to outfit your personal home gym.

Responder

I was recommended this blog through my cousin. I am no
longer certain whether this publish is written via him as no
one else understand such specified about my problem.
You are incredible! Thank you!

Responder

After looking over a few of the articles on your website, I seriously like your technique of blogging. I book marked it to my bookmark site list and will be checking back soon. Please check out my web site too and let me know how you feel.

Responder

I really like it when people come together and share thoughts.
Great site, continue the good work! 3aN8IMa cheap flights

Responder

This is the perfect webpage for everyone who would like to understand this topic. You understand a whole lot its almost hard to argue with you (not that I actually will need to…HaHa). You certainly put a fresh spin on a subject which has been discussed for many years. Great stuff, just wonderful!

Responder

Hello there! This post couldn’t be written much better! Going through this article reminds me of my previous roommate! He always kept talking about this. I will forward this post to him. Pretty sure he’s going to have a good read. Thank you for sharing!

Responder

Your style is very unique compared to other folks I’ve read stuff from. Thanks for posting when you’ve got the opportunity, Guess I’ll just bookmark this site.

Responder

What’s up, yup this piece of writing is in fact nice and I have learned lot of things from it regarding blogging.
thanks.

Responder

I’m impressed, I must say. Seldom do I come across a blog that’s equally educative and entertaining, and without a doubt, you have hit the nail on the head. The problem is something not enough people are speaking intelligently about. I’m very happy I found this in my search for something relating to this.

Responder

This web site really has all of the info I wanted concerning this subject and didn’t know who to ask.

Responder

Hi, I do think this is a great website. I stumbledupon it 😉 I will come back once again since i have saved as a favorite it. Money and freedom is the greatest way to change, may you be rich and continue to help others.

Responder

Spot on with this write-up, I honestly believe this web site needs much more attention. I’ll probably be returning to read through more, thanks for the info!

Responder

The next time I read a blog, Hopefully it doesn’t disappoint me as much as this particular one. After all, I know it was my choice to read through, but I truly believed you would probably have something interesting to say. All I hear is a bunch of complaining about something that you could possibly fix if you weren’t too busy seeking attention.

Responder

We tested coffee makers for the water temperature during the brew cycle and the brewing time as well as the temperature of the coffee at the end of brewing and during the keep warm cycle. In addition, we evaluated each brewer’s ease of use, including how easy it was to read and use the controls, access the water tank and brew basket, read the markings on the tank and carafe, whether or not it had automatic keep warm and shut off cycles, and the ease of cleaning the carafe.

Responder

The very next time I read a blog, I hope that it doesn’t fail me as much as this one. I mean, I know it was my choice to read, nonetheless I really thought you would probably have something useful to talk about. All I hear is a bunch of moaning about something that you can fix if you weren’t too busy seeking attention.

Responder

Everyone loves it whenever people get together and share thoughts. Great blog, continue the good work!

Responder

I couldn’t resist commenting. Very well written!

Responder

I love it when folks get together and share thoughts. Great blog, keep it up!

Responder

Saved as a favorite, I like your blog!

Responder

Howdy! I simply wish to give you a huge thumbs up for your excellent info you have got right here on this post. I will be coming back to your web site for more soon.

Responder

Good info. Lucky me I recently found your site by chance (stumbleupon). I’ve book marked it for later!

Responder

It’s nearly impossible to find knowledgeable people for this topic, however, you seem like you know what you’re talking about! Thanks

Responder

Very good post. I’m experiencing many of these issues as well..

Responder

This is the perfect blog for anybody who wants to find out about this topic. You realize a whole lot its almost tough to argue with you (not that I actually will need to…HaHa). You certainly put a new spin on a subject that’s been written about for ages. Great stuff, just wonderful!

Responder

This is a topic that is close to my heart… Take care! Where are your contact details though?

Responder

I absolutely love your site.. Pleasant colors & theme. Did you make this site yourself? Please reply back as I’m hoping to create my own personal website and want to learn where you got this from or exactly what the theme is named. Thank you!

Responder

Excellent blog you have here.. It’s difficult to find high-quality writing like yours nowadays. I truly appreciate people like you! Take care!!

Responder

Howdy! Quick question that’s totally off topic. Do you know how to make your site mobile friendly? My website looks weird when viewing from my iphone 4. I’m trying to find a theme or plugin that might be able to correct this problem. If you have any recommendations, please share. Cheers!

Responder

I was able to find good advice from your content.

Responder

Greetings, I do believe your blog could be having internet browser compatibility issues. Whenever I look at your website in Safari, it looks fine but when opening in I.E., it’s got some overlapping issues. I just wanted to give you a quick heads up! Apart from that, excellent site!

Responder

Right here is the right website for anybody who hopes to understand this topic. You realize a whole lot its almost tough to argue with you (not that I actually will need to…HaHa). You definitely put a brand new spin on a subject that’s been discussed for ages. Great stuff, just great!

Responder

When I initially commented I seem to have clicked the -Notify me when new comments are added- checkbox and from now on whenever a comment is added I receive 4 emails with the same comment. There has to be a means you are able to remove me from that service? Thanks a lot!

Responder

Everyone loves it when individuals come together and share views. Great website, keep it up!

Responder

Everyone loves it when people get together and share thoughts. Great website, continue the good work!

Responder

Very nice article. I certainly appreciate this site. Stick with it!

Responder

That is a great tip particularly to those new to the blogosphere. Brief but very precise info… Thank you for sharing this one. A must read post!

Responder

Having read this I believed it was rather enlightening. I appreciate you taking the time and energy to put this content together. I once again find myself personally spending a lot of time both reading and leaving comments. But so what, it was still worthwhile!

Responder

I blog frequently and I really appreciate your content. The article has really peaked my interest. I’m going to bookmark your website and keep checking for new details about once per week. I subscribed to your Feed too.

Responder

This is the right site for anyone who hopes to understand this topic. You know so much its almost tough to argue with you (not that I personally will need to…HaHa). You definitely put a fresh spin on a subject which has been discussed for decades. Great stuff, just wonderful!

Responder

I couldn’t refrain from commenting. Well written!

Responder

There’s definately a great deal to know about this issue. I love all the points you’ve made.

Responder

Hi! I could have sworn I’ve been to this blog before but after going through many of the articles I realized it’s new to me. Anyhow, I’m definitely delighted I came across it and I’ll be bookmarking it and checking back regularly!

Responder

Everything is very open with a precise clarification of the issues. It was definitely informative. Your website is very useful. Many thanks for sharing!

Responder

I couldn’t resist commenting. Perfectly written!

Responder

Oh my goodness! Impressive article dude! Thanks, However I am having issues with your RSS. I don’t know why I can’t subscribe to it. Is there anybody having similar RSS issues? Anyone who knows the answer will you kindly respond? Thanx!!

Responder

I used to be able to find good info from your articles.

Responder

bookmarked!!, I really like your website!

Responder

You’ve made some good points there. I checked on the web for more info about the issue and found most individuals will go along with your views on this web site.

Responder

You need to be a part of a contest for one of the most useful websites on the web. I most certainly will recommend this blog!

Responder

Aw, this was an exceptionally good post. Spending some time and actual effort to make a good article… but what can I say… I put things off a lot and never manage to get nearly anything done.

Responder

This is the right webpage for everyone who wishes to find out about this topic. You realize so much its almost hard to argue with you (not that I actually would want to…HaHa). You certainly put a brand new spin on a subject that has been discussed for ages. Great stuff, just excellent!

Responder

Hi, I do think this is an excellent site. I stumbledupon it 😉 I am going to come back once again since I book marked it. Money and freedom is the best way to change, may you be rich and continue to help other people.

Responder

After looking over a handful of the articles on your site, I seriously like your technique of writing a blog. I added it to my bookmark website list and will be checking back soon. Please visit my website too and let me know what you think.

Responder

Hello there! I could have sworn I’ve visited this site before but after looking at some of the articles I realized it’s new to me. Anyhow, I’m definitely happy I found it and I’ll be bookmarking it and checking back often!

Responder

I was able to find good advice from your blog posts.

Responder

Great information. Lucky me I recently found your blog by chance (stumbleupon). I’ve bookmarked it for later!

Responder

Great information. Lucky me I came across your blog by chance (stumbleupon). I have bookmarked it for later!

Responder

Howdy! I just wish to give you a huge thumbs up for the excellent info you have here on this post. I am returning to your web site for more soon.

Responder

It’s difficult to find well-informed people about this subject, however, you sound like you know what you’re talking about! Thanks

Responder

Hi! I could have sworn I’ve visited this site before but after looking at many of the posts I realized it’s new to me. Anyhow, I’m certainly happy I found it and I’ll be bookmarking it and checking back frequently!

Responder

I used to be able to find good advice from your articles.

Responder

This excellent website really has all of the information I wanted about this subject and didn’t know who to ask.

Responder

An intriguing discussion is worth comment. I believe that you should publish more on this issue, it might not be a taboo matter but generally people do not speak about such issues. To the next! Best wishes!!

Responder

After I originally left a comment I appear to have clicked on the -Notify me when new comments are added- checkbox and from now on whenever a comment is added I receive 4 emails with the exact same comment. There has to be a means you can remove me from that service? Thank you!

Responder

Very good information. Lucky me I came across your blog by chance (stumbleupon). I have book marked it for later!

Responder

Greetings! Very helpful advice within this post! It’s the little changes which will make the most significant changes. Many thanks for sharing!

Responder

This is a topic which is close to my heart… Cheers! Where are your contact details though?

Responder

Great info. Lucky me I came across your website by accident (stumbleupon). I’ve saved it for later!

Responder