| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with programmingBorders
How can I place Borders around indivedule cells in a range?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with programmingBorders
Example:
Range("your range").Borders.LineStyle = xlContinuous -- Regards, "Al" wrote: How can I place Borders around indivedule cells in a range? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with programmingBorders
Thank you very much liz, it worked. I am also trying to lock the same range
for editing. I used allowedits = false but it did not work. could you help? thanks Al "Liz" wrote: Example: Range("your range").Borders.LineStyle = xlContinuous -- Regards, "Al" wrote: How can I place Borders around indivedule cells in a range? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with programmingBorders
Range("Your Range").Locked = True
-- Regards, "Al" wrote: Thank you very much liz, it worked. I am also trying to lock the same range for editing. I used allowedits = false but it did not work. could you help? thanks Al "Liz" wrote: Example: Range("your range").Borders.LineStyle = xlContinuous -- Regards, "Al" wrote: How can I place Borders around indivedule cells in a range? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
