I am writing some Excel V4.0 macros in which I issue the PRINT
function. I need to branch to a sub macro when the user Cancels from
the 'Now Printing' dialogue box.
To achieve this I am using the ERROR function which seems to do the
trick but is not consistent in its behaviour (ie. sometimes it appears
to trap the Cancel and other times it doesn't). Is this the correct
function to use for this purpose? or am I not using it correctly? I
find the Function Reference Manual explanation of its use very hard to
My code goes roughly as follows...
ERROR(TRUE,sub macro name)
I am not sure whether I am supposed to turn error checking back on or
off also at some other part in my code.
I would be very grateful for any assistance and can supply further
detail if required.