• 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.

Check Macro setting

S

sms2luv

Member
My file is used by several people, however many are not aware about enabling macro in excel.
I want that the user should get a message on screen that macros are disabled in their system and for the file to work, they have to enable macros.
I went through several sites and came to know that I have to use workbook open event.
Also we need to create a new sheet which will be displayed in case macros are disabled.
I did not understand the code
Would appreciate, if you can help with example
 
Hi,
I downloaded the file and used it.
I copied entire code and made 2 new sheets as well of the same name.
When I reopened the file, I got a prompt to enable macros.
After I enable it, I get a new page that macro is enabled.
However I do not see any other sheets, I guess all sheets are veryhidden.

Can I put my dashboard in this sheet directly.
 
Yes, go ahead and upload your file(s) here and we'll try to see what's wrong.
 
You must log in or register to reply here.
Back
Top