Macro to run Macros

Blazerguy64

New Member
Joined
Nov 16, 2005
Messages
2
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!
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
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

New Member
Joined
Nov 16, 2005
Messages
2
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,117
Messages
5,570,278
Members
412,316
Latest member
JabirS
Top