compile error sub or function not defined excel 2003

[FjChris]

Ladies and Gentlemen,

after having searched the forums and applied some of the previously given solutions of similar problems i decided to post my question here. I got a script that gives me the "compile error sub or function not defined". I am using Excel 2003 and i personally suspect it might have something to do with language issues. The excel version i am using is set to Portuguese but I used some German and English in my code.

Please Login or Register  to view this content.

I appreciate any answers and help and appologize if this is a ridiculous question but its the first time i am programming something myself.

Greetings,
Chris

[romperstomper]

Where is prcDeleteButton defined?

[FjChris]

Where is prcDeleteButton defined?

actually i did not define this one so far, i used a standard worksheet and added a macro for a button in the worksheet so our managers can simply print out the respective worksheet when needed.

Thank you for your reply !

[romperstomper]

You'll need to either create it or remove the call to it from your Workbook_Open code.

[FjChris]

Sorry for not having continued our approach but we had a few extraordinary occurrences around here that kept me from chasing after my makro.

Still having deleted the deletebutton has not resulted in the desired stability.
Actually i am trying to do the following, i have a simple worksheet or lets say 7 in my book in which our store managers will be able to fill in their respective customer orders per day of the week. I added a button that i called "print out" and a macro in order to actually print something out when going for the button. It works but i still get the error when starting up the file and the debugger pops up. Often our managers have minimal to little IT skills and might get confused with unexpected error messages. I just want that dang think to work without any errors.

Thanks for your help

[romperstomper]

If you have a button in the worksheet to do what you want, then you don't need the Workbook_Open code you posted, so just delete it.

[FjChris]

Romperstomper thank you very much! Sweet and simple solution makes me feel like i am a complete moron. Btw is there any kind of decent tutorial that you recommend to get a hang of macros?

Thank you very much and owing you a pint!

Chris