Okay, this is kind of emabarrasing.
A couple of months ago, I added a message box to a spreadsheet so that when my colleagues opened it, they were prompted for certain information. Dead simple, nothing flashy.
It has now served it's purpose and I wanted to remove the message box. I've been into VB Editor to remove it and there is no code for a message box on opening - there is no code for anything!
Please - someone save me from my own stupidity and tell me what I'm doing wrong? Where is the code for this likely to be?
PS - we've upgraded to Office 2000 from 97 since I put it on; will that have anything to do with it?
A couple of months ago, I added a message box to a spreadsheet so that when my colleagues opened it, they were prompted for certain information. Dead simple, nothing flashy.
It has now served it's purpose and I wanted to remove the message box. I've been into VB Editor to remove it and there is no code for a message box on opening - there is no code for anything!
Please - someone save me from my own stupidity and tell me what I'm doing wrong? Where is the code for this likely to be?
PS - we've upgraded to Office 2000 from 97 since I put it on; will that have anything to do with it?
