Reply to author but make the appropriate change to my munged email address.
Gord
On Thu, 19 May 2011 12:24:20 -0700 (PDT), Takeadoe <(E-Mail Removed)> wrote:
>On May 19, 3:13*pm, Gord Dibben <phnor...@shaw.ca> wrote:
>> Did you download the workbook with all the Color Functions from Chip's site?
>>
>> Is it open?
>>
>> If so then the functions will be available for ALL open workbooks.
>>
>> I have no idea where your original code may be stored but if it works only in
>> one workbook I would guess that the code is in a module in that workbook and it
>> is the only workbook you have open at the time.
>>
>> When it "does not work" what error message are you getting.
>>
>> If you want you could send the workbook that "works" to my email.
>>
>> Change phnorton to gorddibb
>>
>> Gord
>>
>>
>>
>> On Thu, 19 May 2011 11:11:26 -0700 (PDT), Takeadoe <mtonkov...@msn.com> wrote:
>> >Gord - Just to follow up to make sure I'm clear. *If I search my
>> >computer for the following text: "If
>> >IsValidColorIndex(ColorIndex:=DefaultColorIndex) " I should locate
>> >it? *Second, the function must be "configured" to only work in that
>> >workbook where it is currently working?
>>
>> >Mike- Hide quoted text -
>>
>> - Show quoted text -
>
>I will download the workbook first and let you know. As for sending
>you an email. Thank you. I may take you up on that. Do I simply hit
>reply to author? Don't use these regularly.
>
>Thanks for the help and your patience.
>
>Mike
|