Hi, I'd like to create a popup that contains a subset of data from the open workbook when a user clicks on a cell. I want the functionality of a spreadsheet, so a userform won't work. I also want the new workbook to open up to a specified size each time. I don't need to save the newly opened workbook.
I assume my starting point would be:
Workbooks.Add xlWorksheet
and then refer to a template file set up the way I want. However, can a template be set up to open a workbook as a certain size??
Is there a better way to accomplish opening up a new worksheet (or something else)?
Thanks!
I assume my starting point would be:
Workbooks.Add xlWorksheet
and then refer to a template file set up the way I want. However, can a template be set up to open a workbook as a certain size??
Is there a better way to accomplish opening up a new worksheet (or something else)?
Thanks!