Hi Dave

It would be handy if you could post some code so we have an opportunity to
see whats happening.

If you are unsure how to access the code, <ALT+F11 will open the VBE Window
and you will be able to access Modules that are attached to the file which
will appear in the Left window pane in the section just under ThisWorkbook.

Cheers
Mick.