VB Script Help For Microsoft Excel
-
Hi Guys! I am in a bit of a Dilemma here again. As much as office 2007 has provided more options in Excel, it has made it darn difficult to do things which were so easy until Office 2003. The problem is, I want to create macros which change the background color of the selected cells according to the company colors. There are 6 different colors which need to be applied. I did the record macro option which works fine and places icons next to the save button on the top left corner in Excel 2007. But my boss wants something different, he want a seperate ribbon with the different color options and also that it should be an add-in otherwise it would be hard to implement all these macros on more than 600 computers world-wide. Can anyone please help me out with this one. I have no experience with VB.Net or Microsoft Office programming. I am a web developer but this is something that has been haunting me for a few days now. To wrap it up, I need to make an Add-In for Microsoft Office 2007 which sits in its own ribbon and has 6 different options. All these options change the background colors respectively, of the selected cells in Excel and needs to be easy to implement by the staff world-wide, we can just provide them with the add-on to run on their computers. Also, this would need to cater for the existing files as well which takes the template files out of the question unless there is a way to make the template file as the default sheet that opens up the existing data. Any help, suggestions, examples or references will be highly appreciated. Thanks.
-
Hi Guys! I am in a bit of a Dilemma here again. As much as office 2007 has provided more options in Excel, it has made it darn difficult to do things which were so easy until Office 2003. The problem is, I want to create macros which change the background color of the selected cells according to the company colors. There are 6 different colors which need to be applied. I did the record macro option which works fine and places icons next to the save button on the top left corner in Excel 2007. But my boss wants something different, he want a seperate ribbon with the different color options and also that it should be an add-in otherwise it would be hard to implement all these macros on more than 600 computers world-wide. Can anyone please help me out with this one. I have no experience with VB.Net or Microsoft Office programming. I am a web developer but this is something that has been haunting me for a few days now. To wrap it up, I need to make an Add-In for Microsoft Office 2007 which sits in its own ribbon and has 6 different options. All these options change the background colors respectively, of the selected cells in Excel and needs to be easy to implement by the staff world-wide, we can just provide them with the add-on to run on their computers. Also, this would need to cater for the existing files as well which takes the template files out of the question unless there is a way to make the template file as the default sheet that opens up the existing data. Any help, suggestions, examples or references will be highly appreciated. Thanks.
Sounds like your boss needs to be put in charge of paper clips or something mildly clerical.
------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
-
Hi Guys! I am in a bit of a Dilemma here again. As much as office 2007 has provided more options in Excel, it has made it darn difficult to do things which were so easy until Office 2003. The problem is, I want to create macros which change the background color of the selected cells according to the company colors. There are 6 different colors which need to be applied. I did the record macro option which works fine and places icons next to the save button on the top left corner in Excel 2007. But my boss wants something different, he want a seperate ribbon with the different color options and also that it should be an add-in otherwise it would be hard to implement all these macros on more than 600 computers world-wide. Can anyone please help me out with this one. I have no experience with VB.Net or Microsoft Office programming. I am a web developer but this is something that has been haunting me for a few days now. To wrap it up, I need to make an Add-In for Microsoft Office 2007 which sits in its own ribbon and has 6 different options. All these options change the background colors respectively, of the selected cells in Excel and needs to be easy to implement by the staff world-wide, we can just provide them with the add-on to run on their computers. Also, this would need to cater for the existing files as well which takes the template files out of the question unless there is a way to make the template file as the default sheet that opens up the existing data. Any help, suggestions, examples or references will be highly appreciated. Thanks.
Here is an article about doing what you need: http://www.c-sharpcorner.com/UploadFile/ptmujeeb/625/Default.aspx[^]
My advice is free, and you may get what you paid for.
-
Sounds like your boss needs to be put in charge of paper clips or something mildly clerical.
------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
Or tied to a home made rocket and shot to the space... lol
-
Here is an article about doing what you need: http://www.c-sharpcorner.com/UploadFile/ptmujeeb/625/Default.aspx[^]
My advice is free, and you may get what you paid for.
Hey mate! Thanks for that. An amazing article and very user friendly. But now I am stuck on the part where I need to call the function to make the color change. I tried to copy the code from the macro but that keeps giving me weird errors like MissingMemberException: Public member 'Selection' on Type 'RibbonButton' not found etc Any reference on this would be great. I am googling myself as well but would like to thank in advance. regards.
-
Hey mate! Thanks for that. An amazing article and very user friendly. But now I am stuck on the part where I need to call the function to make the color change. I tried to copy the code from the macro but that keeps giving me weird errors like MissingMemberException: Public member 'Selection' on Type 'RibbonButton' not found etc Any reference on this would be great. I am googling myself as well but would like to thank in advance. regards.
You're welcome. Unfortunately I have not had to do any projects like this myself, so I haven't tried the code or anything. Your best bet might be to send the author of the article a message.
My advice is free, and you may get what you paid for.