Hi out there,
I have a problem that I have spent hours on without success:
I have 2 worksheets, amongst many, for a user to complete, they are both identical in all respects, including macros that unprotect and hide rows dependent on cell content. The different names being "Hotel 1" & "Hotel 2" (the information input into each of these worksheets is different such as dates, hotel names etc.)
The problem is that the codes work perfectly on either of these worksheets until the second is open and used. The codes appear to interact somehow and conflict with each other (it is as if the codes/worksheets are linked in some way).
Any suggestions will be gratefully received.
Regards,
OldSoldier