Hi All,
I have a workbook with 2 modules to print either a quotation or an order which the user will have generated on a Data Input worksheet.
I want to force the users to enable macros when they open the workbook, otherwise they cannot continue working.
I have put some code I found on the web in a separate module. I need assistance as I cannot manage to call module 3.
I uploaded a copy of the sample file for easy reference. I am sure that someone will help me, like in the past!
Thanks
Fieres
If macros are disabled.....doesn't matter what code you put in there, it isn't going to run.
What I've done in the past is put a 'loading' screen in the workbook, hidden (very) all the other worksheets in the workbook and on the loading screen, in very big text are the words:
"If you can still see this message after a few seconds of opening this workbook then your macros are disabled. You MUST enable macros and re-open this workbook to continue."
And the workbook open event is then used to hide the loading screen and unhide all other sheets.
I think your problem is that much of the code in module 3 are workbook events, and they need to be in the "ThisWorkbook" section of VBA, not a normal module. In VBA editor, double-click on "ThisWorkbook", and put the code there instead of a normal module.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Thanks to all. It is solved & works gr8!
mvassallo, please remember to mark the thread as solved? Thanks in advance
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks