Thread: Autorun macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peter Jausovec
 
Posts: n/a
Default Autorun macro

Hi Kelly,

You should put your macro code in Workbook_Open (in VBA editor double click
on ThisWorkbook and from the second combobox select Open).

Hope this helps.
--
Best regards,
Peter JauĊĦovec
http://blog.jausovec.net
http://office.jausovec.net


"Kelly" je napisal:

I have tried insert code into a macro that will not allow users to use the
cut/copy and past mode. It didn't work. I was told to make it an auto run
macro every time the users open the file. I'm not sure how to make it auto
run. Any suggestions?
--
Thank you, Kelly