On Jul 16, 11:22 am, Dave Peterson wrote:
If you have the option to force declarations of variables turned on, then
rightclicking on a worksheet tab and selecting view code could cause "option
explicit" to be added to the worksheet module--not a general module.

That's enough to cause the warning the next time the workbook is opened.


Thanks Dave! I appreciate your time to reply with a great answer.