Getting raw data from a macro'd workbook

[pheffley]

I have an Excel workbook that was designed to provide calculated data from 1-M worksheets based on the selection. All I see when I open this file is the menu screen where several radio buttons are grouped. Once one is selected and you click the calculate button, a formatted spreadsheet appears.

I need to be able to access the raw data that these calculations are based on. I don't see any other worksheets on the tabs at the bottom. I also looked at the VB code and tried to parameter worksheet("...").visible to True instead of False, but that didn't change anything.

Any ideas?

Thanks,

Paul

 

[Rjc8513]

Have you interrupted the macros/VBA code so that you can examine the entire workbook?

If so, have you tried to unhide the worksheets from the "Format" menu?

How about looking for named ranges from the drop-down in the "Name Box"?