Can't you just put a ' infront of the code you don't want
to be executed, thus making it a comment while you don't
want it to run.
-----Original Message-----
Hi

Please can someone provide a code snipprt or an idea to
solve this neatly

I have a utility that does some predetermined formatting
on generic
worksheets. In normal use it is used on ONE sheet at a
time by the user.
S/he may then use it later on another sheet.

I want to test modifications against a set of sheets in a
workbook
consecutively in one go, which is fine but the routine
itself has a MSGBOX
command in it if it finds a particalar condition. I need
to suppress this in
the multi-sheet test. Otherwise it will be stopping
unnecessarily as I would
test that Msgbox condition independently.

Can someone provide a suggestion,pl?

Pl post back if above is not clear enough to enable a
response.

Thanks

Tim




.