View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Cortez Cortez is offline
external usenet poster
 
Posts: 38
Default Can a macro be run on opening the file?

On Mar 8, 2:13 pm, Lauren Giles
wrote:
Yes! See the following Microsoft web page:http://office.microsoft.com/en-us/ex...346281033.aspx

"Cortez" wrote:
Does anyone know if you can create a macro that is initiated when the
file is opened? I have a number of users that will need to work with
an original (master) document. I want them to open the master file,
and have a macro save the file as a new unique spreadsheet. I know
how to do what I need from a macro, but I would like to have the macro
run without being keyed in by the user.


Any ideas?


Thanks,
TK



Thanks Lauren and Dave. Exactly what I needed.

TK