Read the error message, it couldn;t be much clearer if it tried:
Quote:
Cannot run the macro ...The macro may not be available in the workbook or all marcros may be disabled
So there are two possibilities:
1) "The macro may not be available in the workbook" - check the macro code exists in the same workbook as the code you are trying to execute. If it isn't ... it can't be run!
2) "all marcros may be disabled" - this is pretty likely: file macros are often disabled across the whole of Office for security reasons (IIRC that's even the default these days). If macros are disabled, no macro can be run.