Private Scripts
🛑 ALL INFORMATION CLICK HERE 👈🏻👈🏻👈🏻
Private Scripts
Sign up with email
Sign up
Sign up with Google
Sign up with GitHub
Sign up with Facebook
Asked
8 years, 8 months ago
Active
5 years, 6 months ago
3,812 11 11 gold badges 32 32 silver badges 51 51 bronze badges
2,507 10 10 gold badges 38 38 silver badges 63 63 bronze badges
You mean only runnable if you are inside that particular VBA project?
– brettdj
Jun 2 '12 at 10:27
@brettdj, yes, that's what I mean.
– TPR
Jun 2 '12 at 10:47
52.2k 15 15 gold badges 107 107 silver badges 170 170 bronze badges
but what if want another macro to call it even when it's unauthorized?
– TPR
Jun 2 '12 at 11:27
135k 15 15 gold badges 188 188 silver badges 234 234 bronze badges
you might want to make the parameter optional, and possibly make it long, or a string, so people can't just try True or False to get the code to run
– SeanC
Jun 3 '12 at 3:44
Making the parameter Optional will defeat the purpose :) Yes you have a point regarding the making it long or string. I leave the decision with the Asker :)
– Siddharth Rout
Jun 3 '12 at 3:48
Senior React/RN Developer (React, RN, TypeScript, Mobx)
Ruby on Rails Developer (m/w/d) - Remote
JPMorgan Chase Bank, N.A. Moscow, Russia
Juni Technology AB No office location
Juni Technology AB No office location
Stack Overflow
Questions
Jobs
Developer Jobs Directory
Salary Calculator
Help
Mobile
Disable Responsiveness
Products
Teams
Talent
Advertising
Enterprise
Company
About
Press
Work Here
Legal
Privacy Policy
Terms of Service
Contact Us
Stack Exchange Network
Technology
Life / Arts
Culture / Recreation
Science
Other
Join Stack Overflow to learn, share knowledge, and build your career.
I know that even private vba scripts can be called by the user, such that making it "private" in fact only hides its name.
However, is there a way to set up a macro so it is only runnable if you are inside that particular VBA project? Not from Excel and not from any VBScript or the likes.
If you want to lock down the code you could
The sample code below checks that the VBA in the host workbook is not protected before running
Honestly, there is no foolproof way around it. You can have certain checks but that's all you can do.
If you are sure that a user will not have access to VBA Code then what brettdj suggested is the best way to go ahead. Protect your project. One cannot run a macro from Excel or from outside Excel if one doesn't know the macro name ;)
The basic intention of making a macro Private is not to prevent it from running but making it invisible to the user. Mostly, the only macros that needs to be private in Excel are the inbuilt Worksheet or Workbook events or macros referred by other macros which necessarily don't need to be accessed by the user. A user can still access them from outside VBA if he or she wants to.
Having said that, you can restrict ( But not STOP - Not referring to disabling your macro security ) the macros from running. Pass an authorization FLAG. Only when it receives an "Authorization", will it run.
Now if you want this macro to be called from VBA then you have to call it like this
This will ensure that the above macro will only run when you allow it to.
Would this method prevent user from running this from VBS?
NO. It won't. However, it won't run till the time the user specifies or gives the "Authorization"
By clicking “Post Your Answer”, you agree to our terms of service , privacy policy and cookie policy
To subscribe to this RSS feed, copy and paste this URL into your RSS reader.
site design / logo © 2021 Stack Exchange Inc; user contributions licensed under cc by-sa . rev 2021.2.2.38474
RbxScripts - Scripts for every day!
excel - vba private scripts - Stack Overflow
Private PHP Scripts from CodeCanyon
User scripts | Starve.io Private Servers. JS - try to take over the world!
Private Scripts - OSBot :: 2007 OSRS Botting | Forum
You found 103 private PHP scripts from $6. All from our global community of web developers.
Best match Best sellers Newest Best rated Trending Price Sort order
Star-Full Star-Full Star-Full Star-Full Star-Full
Star-Full Star-Full Star-Full Star-Full Star-Full
Star-Full Star-Full Star-Full Star-Full Star-Half-Empty
Star-Full Star-Full Star-Full Star-Full Star-Full
Star-Full Star-Full Star-Full Star-Full Star-Full
Star-Full Star-Full Star-Full Star-Full Star-Half-Empty
Star-Full Star-Full Star-Full Star-Full Star-Full
Star-Full Star-Full Star-Full Star-Full Star-Full
Star-Full Star-Full Star-Full Star-Full Star-Half-Empty
Star-Full Star-Full Star-Full Star-Half-Empty Star-Empty
Star-Full Star-Full Star-Full Star-Half-Empty Star-Empty
Star-Full Star-Full Star-Full Star-Half-Empty Star-Empty
Star-Full Star-Full Star-Full Star-Full Star-Half-Empty
Star-Full Star-Full Star-Full Star-Full Star-Full
Star-Full Star-Full Star-Full Star-Full Star-Empty
Star-Full Star-Full Star-Full Star-Full Star-Half-Empty
Star-Full Star-Full Star-Full Star-Full Star-Half-Empty
Star-Full Star-Full Star-Full Star-Full Star-Half-Empty
Star-Full Star-Full Star-Full Star-Half-Empty Star-Empty
Star-Full Star-Full Star-Full Star-Half-Empty Star-Empty
Star-Full Star-Full Star-Full Star-Full Star-Full
Quick Links Explore popular categories
About Envato Careers Privacy Policy Sitemap All prices are in USD © 2021 Envato Pty Ltd. Trademarks and brands are the property of their respective owners.
Deliver better projects faster. Web, design & video assets
Unlimited downloads, from $16.50/month
Effortless design and video. Made online by you.
Smart templates ready for any skill level.
Designers matched perfectly to you on Envato Studio
2000 artists ready to undertake your work
Japanese Grannies Porno
Jayne Mansfield Lingerie
Big Ass Women
Toddler Vagina Pee
Outdoor Bicycle
