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
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
blog.jausovec.net
office.jausovec.netquot;Kellyquot; je napisal:
gt; I have tried insert code into a macro that will not allow users to use the
gt; cut/copy and past mode. It didn't work. I was told to make it an auto run
gt; macro every time the users open the file. I'm not sure how to make it auto
gt; run. Any suggestions?
gt; --
gt; Thank you, Kelly
- Aug 28 Tue 2007 20:38
Autorun macro
close
全站熱搜
留言列表
發表留言