code that will delete and clear specific contents in the workbook

**Khanzaki** · 07-31-2013, 02:09 PM

Hi everyone,
I don't know whether it is possible in excel or not.
I have an invoice template which contains macros formula and a data validation list source in it . Now I need a macro that would remove these data from the workbook if the workbook is saved by different name or any other way to automate this task of clearing the above mentioned content using macro
For example:
My Invoice template is named United Printer.xlsb ( it will contain all the data ie "macros formula and a data validation list source in it")
Now when I save this template with a different file name let for example 1254.xlsb it should run the macro and clear the above mentioned data
This post has been edited from here
http://www.thecodecage.com/forumz/mi...-workbook.html

Replies awaited .
Thanks
MZ

**codeslizer** · 07-31-2013, 05:13 PM

To Clear out contents from cells, we basically use ClearContents() available within Range() or Cells(). You simply have to select those ranges first, say if they are from A1 to A100, then code would be

Please Login or Register  to view this content.

To delete the validations, we use Validation.Delete() available within Range() and Cells(). So if we have validation in cells A2 to A3, then

Please Login or Register  to view this content.

**Khanzaki** · 08-01-2013, 01:54 AM

Hi Codeslizer !
Thanks for your reply and would you tell me have to remove all the macros from the saved workbook ??
And also could you merge those two codes in single ?

**codeslizer** · 08-01-2013, 05:35 AM

In order to remove all of the macros from the sheet, you'll have to do it manually. Open VBA editor using Alt + F11. On the left side of your screen, you'll find Projects list, if not, press CTRL+R.

1. Remove any modules, if available
2. Remove any class modules, if available
3. Double click and open each sheet, and press CTRL+A and then DELETE.

That should do for removing all macros. Please note, you'll have to know the VBA password if security is applied to the file.

Regarding your merging request, it depends. Not all of the codes can be merged together just like that. It depends on the scope of the codes. If a code is programmed to work within the scope of a sheet, then it'll work only in the sheet and not outside it. You'll have to redefine scope for if you wish to consolidate it into one.

**Khanzaki** · 08-01-2013, 08:23 AM

Is it not possible to record your above said procedure to remove all macros from a file and save the thus obtained macro in Personal.xlsb to make it available to all open workbook

**codeslizer** · 08-01-2013, 01:18 PM

Well, you never said you wanted a macro to all macros from the sheets.. :p

check out Ivan's post on this link : http://www.mrexcel.com/forum/excel-q...lications.html

code that will delete and clear specific contents in the workbook

LinkBack

Thread Tools

Rate This Thread

Display

code that will delete and clear specific contents in the workbook

Re: code that will delete and clear specific contents in the workbook

Re: code that will delete and clear specific contents in the workbook

Re: code that will delete and clear specific contents in the workbook

Re: code that will delete and clear specific contents in the workbook

Re: code that will delete and clear specific contents in the workbook

Thread Information

Users Browsing this Thread

Similar Threads

Modify Macro : Clear contents <> Delete

Code to clear contents of specific cells based upon if key exists in other sheets

Delete rows or Clear contents below a specific word is found in Column A

[SOLVED] Conditionally Clear Contents for Specific Range

[SOLVED] Macro to clear & delete contents on other worksheets

Bookmarks

Bookmarks

Posting Permissions