macro for coloring cells

  • Thread starter Thread starter hal9000
  • Start date Start date
H

hal9000

is there a macro for coloring the cells up?
i'd like to color up selected cells as; say
by pressing "ctrl + p".
 
hal9000




You would need to build a macro to do what yoiu whant. But why don'
you use the available toolbar item that does that with one mouse clic
- Available on the Formatting toolba
 
There are no macros by default. You make them yourself and get prompted
"this workbook contrains macros" when you open those files afterwards.

In this case, simply record a macro while coloring a cell and you're almost
there.

HTH. Best wishes Harald
 
You would need to build a macro to do what yoiu whant. But why don't
you use the available toolbar item that does that with
Click to expand...
one mouse click

i'd want to do everything with keyboard if possible.
can you show me an example of code to color up a cell?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to automatically go to the right of the last colored cell 0
How to filter rows data based on background color of individual cells 1
Macro to set cell interior color? 4
Excel VBA 1
Change Color of cell 3
Excel 2007 Problem Paste/Enter Key 0
Summary based on highlighted cells 4
Cell and Object change 1

Back
Top