• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Warning Message to ensure Macros are enabled

G

gumbles

New Member
Hi there, I have a team project file that contains one small macro. My team is not all excel savvy so i would like to put a warning message that forces them to enable macros before they continue.


I have tried to replicate the one chandoo has on his project portfolio but my VBA isnt as awesome as his lol.


I have also looked at the link chandoo has given but this involved creating and hiding worksheets, which seems like unecessary work.


Any ideas or code would be greatly recieved


Gumbles.
 
Unfortunately, the idea of hiding/unhiding sheets is the best way to do it. Until macros are enabled, there's no programming we can do that will help out. (as it's disabled!) Thus, the only recourse we have is to do something physically with the workbook to let people know.
 
Well that makes perfect sense! in that case i shall use that technique.


On the off chance, do you know if this is the technique used by chandoo in his lastest project portfolio, as i think his is very proffesional approcach?


Regards


Gumbles.
 
I'm not sure if it's in Chandoo's latest project. I was able to find this article which shows all the needed codes and step-by-step instructions. Hopefully it helps?

http://www.vbaexpress.com/kb/getarticle.php?kb_id=379
 
You must log in or register to reply here.
Back
Top