macro security message

  • Thread starter Thread starter Edward
  • Start date Start date
E

Edward

Hi everybody,
I have saved many macros in a ppt file ( eventually it will be an add in)
now when I cut and paste the file to somewhere else in my computer I can't
run the macro and I get a message saying that it can't open the file and
shows the old path , and if i copy and paste the file every time i run a
macro I get the macro security message and asking to enable macro. Any
suggestions that helps me to solve this problem?
 
Thanks guys, Okay I think I got the source of this problem , at least I can
explain it correctly . I'm building a template with several macros and I have
added a toolbar and I add new buttons for each macro as they become avaiable.
I work on different files in different location in my computer for writing
the code and testing it and when they work fine I transfer them to my several
copies of final template. I noticed that when I add a button to my toolbar in
final template A and save it and then later I add a button to the same
toolbar in final template B and save it nomatter which template i open I can
see all the macros i have added but when I'm in template A and clcik on a
macro that I have added to the toolbar using template B I get that security
message and vise versa . I guess I answered my question here to avaoid this
I have to make sure to just keep one copy of final template and add every new
macro through that template. I haven't tested this idea but it seems it must
work now. Thanks again.
--
Best regards,
Edward


Shyam Pillai said:
Edward,
Create your own self-cert digital signature and apply it to the VBA project.
Then all you have to do it is trust that certificate.
http://support.microsoft.com/kb/217221


Regards,
Shyam Pillai

OfficeTips: http://skp.mvps.org
Click to expand...
 
allright resaved everymacro through the same template and that solved part of
the problem but still I have the copy and paste problem. Now every macro
works fine but as soon as I move the template to a new location or directory
for every single macro I get macro security message which shows the old
directory of my template and telling me that it has some macros in it ....
I'm going to try shyam's suggestion but is this a known issue in PPT vba ?
because in word and excel we don't have this kind of problem .
--
Best regards,
Edward


Edward said:
Thanks guys, Okay I think I got the source of this problem , at least I can
explain it correctly . I'm building a template with several macros and I have
added a toolbar and I add new buttons for each macro as they become avaiable.
I work on different files in different location in my computer for writing
the code and testing it and when they work fine I transfer them to my several
copies of final template. I noticed that when I add a button to my toolbar in
final template A and save it and then later I add a button to the same
toolbar in final template B and save it nomatter which template i open I can
see all the macros i have added but when I'm in template A and clcik on a
macro that I have added to the toolbar using template B I get that security
message and vise versa . I guess I answered my question here to avaoid this
I have to make sure to just keep one copy of final template and add every new
macro through that template. I haven't tested this idea but it seems it must
work now. Thanks again.
Click to expand...
 
Thanks Steve, as I said when I finish the set of macros I'm writting I will
save it as an add-in and I hope I won't see any of this strange behavior
because I need to distribute this among over 700 people. Now that I have
worked on PP VBA macros for the first time I have to admit PP group in MS is
way behind their counterparts in Word and EXcel groups and I hope this type
bugs are somehow resolved in PP2007. Thanks for letting me know that this is
known issue and has nothing to do with my lack of expirence in PP VBA and the
setting of my computer. One more strange bahavio I noticed last night is when
I copied my PPT ( which has all the forms and macros and custom toolbar) to a
flashdrave and tranfered it to my computer at home all the macros and forms
whene in the PPT file but none of commandbuttons that I created on the custom
toolbar were there !! I don't have explanation for this , have you seen
anything like this before? well , I think we just have to live what we got
and hope MS will improve its PP performance at least from programming
perspective to the same level of Excel and Word.
 
Thanks steve for yoru prompt response in my original PPT file I dont have any
code to create toolbar but every time I open it my custom toolbar is there
but when I copy the file somewhere else or in a new computer I don't have the
toolbar ! I uderstand yoru point and I can certainly add the code to add the
toolbar upon openning but I just dont get the reason why it shows the toolbar
bar on the original file and doesnt show the buttons in the copied version of
the same file !
 
Thanks steve, when I copy or move the file so a different directory in my
computer I can see the toolbar I created but as I said before commandbuttons
don't work properly ( when I clcik on them I get security warnning shpowing
the old path and if my VBA editor is open on my second screen multiple windos
open automatically before eventually macro executes) but when I copy the file
in a different computer I don't have my command buttons) . I haven't
finalized this Add-in but I certainly go with your suggestion and use proper
code to add buttons and see how it will work.
 
Back
Top