I have a multi-sheet workbook that has been working fine until now. The only
change I have made is adding another sheet which has a distinct name from the
pre-existing ones.

However, when I try to use the controls already included on other sheets, I
get this runtime error (the sheet should hide itself on exit from that
particular set of data). If I delete the newly added sheet I still have the
problem in the code that worked fine on other sheets before.

If I rem out the offending code (it's a 'with sheets(name) .visible =
false end with') then it falls over at the next line.

Anyone got any ideas?

Thanks
SJB