Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-30-2023, 08:18 AM
BYahr BYahr is offline Is it possible to use a vba macro to delete other macros? Windows 11 Is it possible to use a vba macro to delete other macros? Office 2021
Novice
Is it possible to use a vba macro to delete other macros?
 
Join Date: Mar 2023
Posts: 16
BYahr is on a distinguished road
Default Is it possible to use a vba macro to delete other macros?


I have successfully created individual macros that update 20 individual spreadsheets. These macros are all stored in a template used daily. For storage reasons, I want to delete the individual macros when the day comes to an end. No need to store 20 macros with each day's workbook when they are in the template.

Each macro has a button to activate it the I delete (cut) once it has been run. I would like to be able to easily delete all the actual macros (modules) when the day's work is completed. I believe the macros can be 'hidden' since there is a button to activate it but that doesn't reduce the storage space needed. It's not much but after 365 days a year it does add up.
Reply With Quote
 

Tags
delete module, macro help



Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to use a vba macro to delete other macros? A few macros or functions run in a single macro? pentagram_31 Word VBA 15 10-29-2018 01:46 PM
Is it possible to use a vba macro to delete other macros? Compatibility of 2 macros in mail merge: Delete table rows + save individual PDFs Btop Word VBA 26 03-07-2018 01:45 PM
URGENT: Macro to open document and apply other macros successively Krategy Word VBA 1 12-02-2016 04:41 PM
VBA Powerpoint Macros: Set String in one Macro, use it in another Martijn6134 PowerPoint 0 11-09-2016 05:36 AM
Macro to find a word in first row of table and then perform two macros hmsrose Word VBA 5 01-30-2015 12:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft