Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formats on Autofilter Headers
I am using code from Debra Dalgeish's website
(http://www.contextures.com/excelfiles.html , FL0018) as an example on how to change the color of a column header if that field is filtered. The code works fine on the spreadsheet I have saved on my personal drive, but I tried to save this on a shared drive, and an error occurred in the following line of code: Range("Q3:AE3").Value = "No Conditions" Is there some restriction in shared workbooks which would not allow this? I have referred to the help, but I can't seem to find anything in the code which would lead to a problem, and outside of changing some cell references, the code is the exact same as Debra's. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formats, how to scroll and view all formats? | Excel Worksheet Functions | |||
How to keep Column headers with Autofilter & Freeze Panes | Excel Discussion (Misc queries) | |||
Conditional formats- paste special formats? | Excel Discussion (Misc queries) | |||
Printing Headers using Criteria chosen from AutoFilter | Excel Programming | |||
Date Formats in Headers/Footers | Excel Programming |