Macro to run Macros

[Blazerguy64]

Hi all, I am new to the world of Excel Macros. I have a slight knowledge of VB Code but it would seem not enough to do what I want to do. I have a Calendar set up in Excel that has a single sheet with a Year at a Glance and then 1 sheet for each of the 12 months. On each of the 12 Months there is a cell for each of 5 people on each day of the month. the cells will be color coded each day, depending on what the person is doing. What I need to accomplish is to have the Color Coding transfer from the Monthly Calendar to the corresponding day on the Year at a Glance Sheet. I have created a macro to go back and forth from 1 sheet to the other copying and pasting the color format. I did this because I could not figure out how to Color both cells at the same time. The macro takes a long time to run and I am afraid that it may cause seizures from all the Blinking. Lastly, I have tried using the call procedure to run 2 or more macros in succession by pressing a button on the spreadsheet, but when the button is pressed, the call procedure gives an error.

Any help at all would be much appreciated by this Newbie!

 

[Oaktree]

Welcome to the board.

For the "...afraid that it may cause seizures from all the blinking" comment, put application.screenupdating = false at the top of your code.

For your other concerns, please post your code.

 

[Blazerguy64]

Thanks Oaktree;

That one piece of info has made the macro much nicer already and I have figured out how to run the macro now from the command button. Only question I really have now is... Is there a way to set up something so that if for example I make the Background Color of cell "B5" on Sheet2 "RED" it will also make cell "C10" on Sheet1 the same color at the same time?