| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to delete Macros
Hi All.........
I must provide a worksheet to a Customer for their perusal. There are several Macros involved that I do not want them to see. What is the code please for me to write a "Sanitize" macro that will delete all macros from the modules, workbook, etc that the Customer need not see ? I tried recording it, to delete individual macros by name, but that part does not show up........ TIA Chuck, CABGx3 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code to delete Macros
http://www.cpearson.com/excel/vbe.htm
but why not protect the code in the VBE? If you do, then you won't be able to delete it, but that form of protection is fairly robust for the average user. ---------- I guess the scenario is not clear. You are giving the book complete to the user, then the code will delete code after a demo? -- Regards, Tom Ogilvy "CLR" wrote in message ... Hi All......... I must provide a worksheet to a Customer for their perusal. There are several Macros involved that I do not want them to see. What is the code please for me to write a "Sanitize" macro that will delete all macros from the modules, workbook, etc that the Customer need not see ? I tried recording it, to delete individual macros by name, but that part does not show up........ TIA Chuck, CABGx3 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code to delete Macros
Take a look at Chip's site http://www.cpearson.com/excel/vbe.htm
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "CLR" wrote in message ... Hi All......... I must provide a worksheet to a Customer for their perusal. There are several Macros involved that I do not want them to see. What is the code please for me to write a "Sanitize" macro that will delete all macros from the modules, workbook, etc that the Customer need not see ? I tried recording it, to delete individual macros by name, but that part does not show up........ TIA Chuck, CABGx3 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code to delete Macros
Thanks Bob.........
A lot more there than I had sense enough to ask for, but from a cursory look, it should solve my problem. Vaya con Dios, Chuck, CABGx3 "Bob Phillips" wrote in message ... Take a look at Chip's site http://www.cpearson.com/excel/vbe.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "CLR" wrote in message ... Hi All......... I must provide a worksheet to a Customer for their perusal. There are several Macros involved that I do not want them to see. What is the code please for me to write a "Sanitize" macro that will delete all macros from the modules, workbook, etc that the Customer need not see ? I tried recording it, to delete individual macros by name, but that part does not show up........ TIA Chuck, CABGx3 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code to delete Macros
it should solve my problem.
For your consideration (posted by Stephen Bullen) Generally when automating the IDE, it's not a good idea to modify your own project. What are you trying to achieve? Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.ie -- Regards, Tom Ogilvy "CLR" wrote in message ... Thanks Bob......... A lot more there than I had sense enough to ask for, but from a cursory look, it should solve my problem. Vaya con Dios, Chuck, CABGx3 "Bob Phillips" wrote in message ... Take a look at Chip's site http://www.cpearson.com/excel/vbe.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "CLR" wrote in message ... Hi All......... I must provide a worksheet to a Customer for their perusal. There are several Macros involved that I do not want them to see. What is the code please for me to write a "Sanitize" macro that will delete all macros from the modules, workbook, etc that the Customer need not see ? I tried recording it, to delete individual macros by name, but that part does not show up........ TIA Chuck, CABGx3 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code to delete Macros
Hmmmmm, methinks I've bit off more than I can chew with this
one...........time for Plan "B" I guess..........."sometimes the Dragon wins" <G Thanks guys........ Vaya con Dios, Chuck, CABGx3 "Tom Ogilvy" wrote in message ... it should solve my problem. For your consideration (posted by Stephen Bullen) Generally when automating the IDE, it's not a good idea to modify your own project. What are you trying to achieve? Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.ie -- Regards, Tom Ogilvy "CLR" wrote in message ... Thanks Bob......... A lot more there than I had sense enough to ask for, but from a cursory look, it should solve my problem. Vaya con Dios, Chuck, CABGx3 "Bob Phillips" wrote in message ... Take a look at Chip's site http://www.cpearson.com/excel/vbe.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "CLR" wrote in message ... Hi All......... I must provide a worksheet to a Customer for their perusal. There are several Macros involved that I do not want them to see. What is the code please for me to write a "Sanitize" macro that will delete all macros from the modules, workbook, etc that the Customer need not see ? I tried recording it, to delete individual macros by name, but that part does not show up........ TIA Chuck, CABGx3 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code to delete Macros
Chuck,
Are you saying that you can't get Chip's code to work? If so, give us the details and we'll help. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "CLR" wrote in message ... Hmmmmm, methinks I've bit off more than I can chew with this one...........time for Plan "B" I guess..........."sometimes the Dragon wins" <G Thanks guys........ Vaya con Dios, Chuck, CABGx3 "Tom Ogilvy" wrote in message ... it should solve my problem. For your consideration (posted by Stephen Bullen) Generally when automating the IDE, it's not a good idea to modify your own project. What are you trying to achieve? Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.ie -- Regards, Tom Ogilvy "CLR" wrote in message ... Thanks Bob......... A lot more there than I had sense enough to ask for, but from a cursory look, it should solve my problem. Vaya con Dios, Chuck, CABGx3 "Bob Phillips" wrote in message ... Take a look at Chip's site http://www.cpearson.com/excel/vbe.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "CLR" wrote in message ... Hi All......... I must provide a worksheet to a Customer for their perusal. There are several Macros involved that I do not want them to see. What is the code please for me to write a "Sanitize" macro that will delete all macros from the modules, workbook, etc that the Customer need not see ? I tried recording it, to delete individual macros by name, but that part does not show up........ TIA Chuck, CABGx3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete macros | Excel Worksheet Functions | |||
| How can I delete all macros? | Excel Discussion (Misc queries) | |||
| How to delete macros | Excel Discussion (Misc queries) | |||
| VBA code delete code but ask for password and unlock VBA protection | Excel Programming | |||
| VBA code to delete VBA code in another Workbook | Excel Programming | |||
![CLR[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
