Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete macros by macro
Hi,
I have workbook where should have access more persons from my company and need to change it. On closing it I have macro (in module of this workbook) to delete some sheets and columns, and save it with another name. This new workbook is read only, but in this way it contents all macros from the first workbook. How can I automatically delete all macros in that new file? Or is there any better solution? Thank you in advance, karmela |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete macros by macro
hi
see this site.... http://cpearson.com/excel/vbe.htm it tells how to manipulate macros with macros. regards FSt1 "karmela" wrote: Hi, I have workbook where should have access more persons from my company and need to change it. On closing it I have macro (in module of this workbook) to delete some sheets and columns, and save it with another name. This new workbook is read only, but in this way it contents all macros from the first workbook. How can I automatically delete all macros in that new file? Or is there any better solution? Thank you in advance, karmela |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete macros by macro
On Oct 6, 11:51 am, FSt1 wrote:
hi see this site....http://cpearson.com/excel/vbe.htm it tells how to manipulate macros with macros. regards FSt1 "karmela" wrote: Hi, I have workbook where should have access more persons from my company and need to change it. On closing it I have macro (in module of this workbook) to delete some sheets and columns, and save it with another name. This new workbook is read only, but in this way it contents all macros from the first workbook. How can I automatically delete all macros in that new file? Or is there any better solution? Thank you in advance, karmela Hello Karmeda, Another option that you may want to consider is Locking the VBA Project for Viewing. Open the Visual Basic Editor and go to Tools VBAProject Properties.. This will bring up a dialog with 2 tabs. Select the Protection Tab. Click the check box to Lock the porject for viewing. You can also password protect the project to prevent the users from clearing th Lock for Viewing option. Sincerely, Leith Ross |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete macros by macro
Hello Leith,
thanks for yout advice, in this case there are auto_close macro, which will run also with protected VBA Karmela Leith Ross pÃ*Å¡e: On Oct 6, 11:51 am, FSt1 wrote: hi see this site....http://cpearson.com/excel/vbe.htm it tells how to manipulate macros with macros. regards FSt1 "karmela" wrote: Hi, I have workbook where should have access more persons from my company and need to change it. On closing it I have macro (in module of this workbook) to delete some sheets and columns, and save it with another name. This new workbook is read only, but in this way it contents all macros from the first workbook. How can I automatically delete all macros in that new file? Or is there any better solution? Thank you in advance, karmela Hello Karmeda, Another option that you may want to consider is Locking the VBA Project for Viewing. Open the Visual Basic Editor and go to Tools VBAProject Properties.. This will bring up a dialog with 2 tabs. Select the Protection Tab. Click the check box to Lock the porject for viewing. You can also password protect the project to prevent the users from clearing th Lock for Viewing option. Sincerely, Leith Ross |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A macro to delete other macros? | Excel Programming | |||
How to Delete Another WorkBook Macros using Macros.. Possible? | Excel Programming | |||
Macro Size Limit / open macros with macros? | Excel Programming | |||
Delete macros in another macro | Excel Programming | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming |