View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
zulfer7 zulfer7 is offline
external usenet poster
 
Posts: 9
Default Need VBA Code to Let User Define Active Sheet

I have a macro that currently pops up a windows explorer box to allow the
user to find an excel spreadsheet to run the macro on. I would like to
change the macro to allow the user to select a currently open active excel
spread sheet on their desktop instead. Any Ideas?