warning box macro

[stevesunfold]

hi guys
i have a very simple macro

Please Login or Register  to view this content.

but i need a warning box to come up warning me that i need to put headed paper into the paper tray

any ideas gratefully received

regards

[protonLeah]

Put a line such as:

Please Login or Register  to view this content.

before the actual print code.

[stevesunfold]

whereabouts proton cheers for the reply

[stevesunfold]

can anyone help?
would be appreciated

[protonLeah]

Please Login or Register  to view this content.

[stevesunfold]

once again thanks for the reply proton and its exactly what i want but after i click ok it then gives me a run time error 1004
youve entered too many arguments for this function
any ideas???

[stevesunfold]

anyone please?
i really need this done by tonight

regards

[protonLeah]

Please delete the '---- lines and the '<<<, etc.
The only line you need to add is:

Please Login or Register  to view this content.

In this case all you need is a short phrase in quotes after MSGBOX

[stevesunfold]

proton
really appreciate your help but still getting the same messsage

[stevesunfold]

bump bump
i would be more than grateful if someone could help me with this

[broro183]

hi Steve,

From your comment that the error is "youve entered too many arguments for this function", it appears that one of your ExecuteExcel4Macro strings has too many commas in it. If you open up the VBE, click in the text between Sub & "End sub" & press [F8] to step through the code, which line of code does it actually error on & highlight?

Try deleting a comma here or there & see what happens ;-)

Why are you using an "ExecuteExcel4Macro" statement, rather than printing directly from your file using the normal code for Printing which you can probably get by recording a macro of your manual actions?

hth
Rob

[stevesunfold]

hi broro

thanks so much for your help
i didnt know you could do that and it helped a lot i now have this working well .
it was a case of too may punctuations

many many thanks

[broro183]

Pleased I could help - thanks for the feedback :-)