I've inherited a set of Spreadsheets which are linked together.
The "opening" Spreadsheet, launches all the others and presents a selection box with a pull down menu and a couple of buttons. Everything else is frozen.
Selecting one or the other button launches a second box with another set of buttons.
Selecting one or the other buttons will start a series of calculations followed by a report being printed., and the selection box disappears.
I need to get to the code being run from these boxes so I can change how data is copied from one of the spreadsheet to another.
I've looked through the macros and can find the one that starts the calculations but in the header it says something to the effect that the initial data transfer as been completed, but no references to how it was done.
I think I need to "un-hide"/unprotect the initial selection boxes to see whats going on, but don't know how.
Suggestions would be welcome.
Thanks in advance
Bookmarks