here is my problem. I am trying to have my workbook update itself an
put it self in a certan format when it opens then saves as a diffren
item. now i want the macro disabled so when i send the file to othe
people they just see the nice part... think ya'll can help me

--
happ
-----------------------------------------------------------------------
happo's Profile: http://www.excelforum.com/member.php...fo&userid=2636
View this thread: http://www.excelforum.com/showthread.php?threadid=39641

Hi happo

Maybe you can test the username in the first line of your macro
If Application.UserName < "Ron de Bruin" Then Exit Sub

Or use my SendMail Add in to send it and use the option to delete the code
http://www.rondebruin.nl/mail/add-in.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"happo" wrote in message
...

here is my problem. I am trying to have my workbook update itself and
put it self in a certan format when it opens then saves as a diffrent
item. now i want the macro disabled so when i send the file to other
people they just see the nice part... think ya'll can help me?


--
happo
------------------------------------------------------------------------
happo's Profile: http://www.excelforum.com/member.php...o&userid=26369
View this thread: http://www.excelforum.com/showthread...hreadid=396412