Hi All
Have been searching the web to no avail.
I have a Master file that generates a new order no on opening... I did not want to have to generate by pressing buttons.
I would then want to save a backup of this file as macro enabled but only disabling the specific macro that generates a new order no and leaving the other macros available.
Any ideas
use this code
This delete ("Module2")
Please Login or Register to view this content.
Last edited by Kamboj; 01-06-2016 at 08:55 AM. Reason: end code
Kamboj
_________________________________________________________________________________
Mark the thread as SOLVED if my answer satisfy you.
Hi Kamboj
Thank you for your reply. I inserted the provided code as per below.....The workbook hangs when running the Save Macro.
Any ideas?
Please Login or Register to view this content.
Hi Kamboj
I found the following code which works perfectly, however what can I add to the code that will first check if module exists to remove and if not, to do nothing.
Please Login or Register to view this content.
Last edited by sintek; 01-06-2016 at 11:27 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks