The error message implies you have pasted the code into a class module rather than a normal module. If you want to keep the code in a class module you will have to change the constant definitions from Public to Private.