I'm using excel 2003. I'm working with a excel file from wayback, so I don't have any resources into how they did what they
did. Here's what I got:
1. We click a button to bring up the data form. No matter what data I have selected, if
I click the button or go through the menu, the same form with the same fields always comes up. I have found some data way
off to the right of the worksheet that has the data in it. It even has X and Y sizes. I can change these numbers and make
the data form change sizes. I just don't know how they have the data form linked to this area of the worksheet.
2. We also have a button that lets us change a name. Its not a data form, but a dialog box. I've found to the far right
of the work sheet parameters that I can change that changes the size of the dialog box. Again, I dont' know how they linked
to this certain area.
3. I've also located a hidden worksheet with some odd(odd to me) entries:
Ok, the only missing link could be: when i go to the visual basic editor there is a few entries other
than my workbook. But they all have passwords. I can't figure the passwords out. But, under the workbook entry I see only
the macros, no forms or anything else.
Do I have enough info above for someone to get me on track to figuring
how the above is being done?
I'm trying to replicate and clean up our program.