when i open my workbook it asked at the top of the screen if I wan to enable content? is it possible to just have it always enabled?
when i open my workbook it asked at the top of the screen if I wan to enable content? is it possible to just have it always enabled?
You can go to File -> Options -> Trust Settings -> Macros and enable all content.
Personally, I'd go into the Trusted Documents tab of the same area of make that single document trusted, or a single location.
VBA is pretty powerful stuff, and bad code can exist even in this petty little code.
A nasty Excel file can wipe your hard drive without warning if everything is always enabled, in less than 100 characters of code.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks