Hello guys,
I need a vba code that will prevent all of the vba from an excel document to run in case i open it.
So in case i open the document the vba will not run but if another user opens it, it should run.
Thanks,
-Alex
Hello guys,
I need a vba code that will prevent all of the vba from an excel document to run in case i open it.
So in case i open the document the vba will not run but if another user opens it, it should run.
Thanks,
-Alex
you can try adding this to the file you're trying to prevent running macros in
if the file already has auto_open then put the line right at top of macro
Sub Auto_Open
if application.username="your user name" then end
end sub
Perhaps something like this:
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks