| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving File with the VB Modules protected giving me an error. Than
In 2003 I was able to save the workbook usin a Exit Macro and with the VB
protected. Now is saying that I have to unprotect the Modules to be able to save the file. I don't want anybody to be messing around the programs. So how can I save it with the protection? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving File with the VB Modules protected giving me an error. Than
You have an active thread elsewhere.
microsoft.public.excel.worksheet.functio wrote: In 2003 I was able to save the workbook usin a Exit Macro and with the VB protected. Now is saying that I have to unprotect the Modules to be able to save the file. I don't want anybody to be messing around the programs. So how can I save it with the protection? Thanks. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving File with the VB Modules protected giving me an error.
What you mean? I have only try to save a file with a Macro and then close the
file authomatically. This used to be ok in 2000 and 2003, but now I have issues with it. Any thoughts? Thanks Argy. "Dave Peterson" wrote: You have an active thread elsewhere. microsoft.public.excel.worksheet.functio wrote: In 2003 I was able to save the workbook usin a Exit Macro and with the VB protected. Now is saying that I have to unprotect the Modules to be able to save the file. I don't want anybody to be messing around the programs. So how can I save it with the protection? Thanks. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving File with the VB Modules protected giving me an error.
Just the one I shared in the other newsgroup.
microsoft.public.excel.worksheet.functio wrote: What you mean? I have only try to save a file with a Macro and then close the file authomatically. This used to be ok in 2000 and 2003, but now I have issues with it. Any thoughts? Thanks Argy. "Dave Peterson" wrote: You have an active thread elsewhere. microsoft.public.excel.worksheet.functio wrote: In 2003 I was able to save the workbook usin a Exit Macro and with the VB protected. Now is saying that I have to unprotect the Modules to be able to save the file. I don't want anybody to be messing around the programs. So how can I save it with the protection? Thanks. -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
| VBA modules protected by password | Excel Programming | |||
| Export Import Modules File Name error | Excel Programming | |||
| Protected modules | Excel Discussion (Misc queries) | |||
| Opening of an excel file is also giving a run time error | Excel Programming | |||
![microsoft.public.excel.worksheet.functio[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
