I would like to be able to click on the sheet I want within a macro and then
continue on with the macro code

for example this code chooses all the sheet within the test workbook and
puts a 0 in A1

Windows("test.xls").Activate
Sheets.Select
Range("A1").Select
ActiveCell.FormulaR1C1 = "0"
Range("A2").Select

instead I want the workbook to pop up so that I can click on a single sheet
I select
and put a 0 in only that single sheet