Option setting mysteriously changes

**Paul** · 07-06-2011, 11:37 AM

When something happens that infrequently I usually give the user a raised eyebrow look and think "Ok, what did you do to cause this?". Rarely do I actually say it, just think it.

Can't say I've ever heard of a bug or conflicting setting that would affect it. Perhaps another macro you ran changes some workbook settings, might even be in another workbook or macro file.

**ianh** · 07-08-2011, 03:29 AM

Originally Posted by Paul

I usually give the user a raised eyebrow look and think "Ok, what did you do to cause this?". Rarely do I actually say it, just think it.

my conversations usually start with me saying "what did you do" and ends with me leaving shaking my head and wondering how this became my problem.

I like my errors nice and consistent and easily replicatable. i dread the helldesk call from a user that sarts off with "well sometimes its just goes kind of funny!

!" FFS

As for a solution to this problem, i fear im no help, and wandering off topic.