View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
belvy123 belvy123 is offline
external usenet poster
 
Posts: 71
Default Macro to select all sheets

Hi All

I am needing help with code for a macro
I want to have this macro run on every opening of file and compare to the
current date. If the date is matched or past the current date I want to
select all sheets in the work book and then clear all data in the sheets. And
then save the file also.
Can anyone help with this

Thanks


--
crunchin numbers