close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()