Hi guys, I was just wondering if there is such a macro for deleting all the macros in a workbook on saving it?
I have a button within my template workbook that when pressed it "saves as" then hides/deletes on the saved workbook but there are still some macros in the workbook that are not needed upon saving. The reason for asking this is that I have to email my workbook to work but I dont want them to open it with the security warning popping up telling them they have to enable macros.
Peter
Hi Peter,
You're using Excel 2007, so have you considered saving the workbook as an xlsx file? This would remove all VBA code from it.
Hello Pedro1803,
This macro will destroy all macro code in workbook before it is saved. If you have locked your VBA project, you need to change the password from "ABC123" to what you are using.
Delete All MAcros Before Saving
Please Login or Register to view this content.
How to Save a Workbook Event Macro
- Copy the macro using CTRL+C keys.
- Open your Workbook and Right Click on any Worksheet's Name Tab
- Left Click on View Code in the pop up menu.
- Press ALT+F11 keys to open the Visual Basic Editor.
- Press CTRL+R keys to shift the focus to the Project Explorer Window
- Press the Down Arrow Key until ThisWorkbook is highlighted in blue.
- Press the Enter key to move the cursor to the Code Window
- Paste the macro code using CTRL+V
- Save the macro in your Workbook using CTRL+S
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
sorry for bumping the old thread, but, I just want to ask, if I assign this code to some button, will it work when I click it?
thanks..
Yes it should work.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks