Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VBA Project - Open/Close with Macro
Hi,
Is there a macro to open and or close a VBA Project? If so, please include a command to protect or unprotect the VBA project. Thank you, DAnny |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VBA Project - Open/Close with Macro
No there are no macros to do this, but what you can do is reference it,
although I don't think that is what you want. If you want to protect your project from prying eyes, after you do Alt F11, Click on Tools - VBA Properties and click on the protection tab and set your password and click on the lock project for viewing check box, save the file close it and reopen for the changes to take effect. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Danny" wrote: Hi, Is there a macro to open and or close a VBA Project? If so, please include a command to protect or unprotect the VBA project. Thank you, DAnny |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VBA Project - Open/Close with Macro
Thanks Michael. No wonder I did not get any response on my previous posting
VBA Password Question "Michael" wrote: No there are no macros to do this, but what you can do is reference it, although I don't think that is what you want. If you want to protect your project from prying eyes, after you do Alt F11, Click on Tools - VBA Properties and click on the protection tab and set your password and click on the lock project for viewing check box, save the file close it and reopen for the changes to take effect. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Danny" wrote: Hi, Is there a macro to open and or close a VBA Project? If so, please include a command to protect or unprotect the VBA project. Thank you, DAnny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow Open & Odd Close | Excel Discussion (Misc queries) | |||
Macro to close workbook and re-open new copy | Excel Discussion (Misc queries) | |||
Macro to Open, then Close another File | Excel Discussion (Misc queries) | |||
Slow to open /close | New Users to Excel | |||
How can I close only 1 workbook when I have many open? | Excel Discussion (Misc queries) |