Not being pedantic - but you cannot declare a Public Variable in another macro... It must be in the General Declarations section of a standard code module. You set the value in a procedure, though.