Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks_beforeclose() function and out of disk space
Hi,
I have disabled the SAVE AS on my sheet, so users will not be able to save documents on their personal folder. I am having trouble dealing with closing the workbook and saving. I am using the workbooks_beforeclose function and ActiveWorkbook.close Save=true or something like that (cant remember th ecorrect syntax). It works fine, but only if there is enough disk space. We have limited disk space. I tried to catch the error with ON ERROR GOTO Errohandler: and at ERRORHANDLER: I do a check if the error is 1004 and display a message to warn users about it and then exit sub. The problem is that excel does not stop the closing process and it then asks if the user wants to save/discard or cancel the changes... Thats because after exit sub in the errorhandler, excell restarts the function again??? How can I avoid this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks_beforeclose() function and out of disk space
The Workbook_BeforeClose function has a Cancel argument. If your error
handler sets this argument to True, the close operation should stop, leaving the workbook open. Hope this helps, Hutch " wrote: Hi, I have disabled the SAVE AS on my sheet, so users will not be able to save documents on their personal folder. I am having trouble dealing with closing the workbook and saving. I am using the workbooks_beforeclose function and ActiveWorkbook.close Save=true or something like that (cant remember th ecorrect syntax). It works fine, but only if there is enough disk space. We have limited disk space. I tried to catch the error with ON ERROR GOTO Errohandler: and at ERRORHANDLER: I do a check if the error is 1004 and display a message to warn users about it and then exit sub. The problem is that excel does not stop the closing process and it then asks if the user wants to save/discard or cancel the changes... Thats because after exit sub in the errorhandler, excell restarts the function again??? How can I avoid this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks_beforeclose() function and out of disk space
Hammer
I have disabled the SAVE AS on my sheet, so users will not be able to save documents on their personal folder. What means have employed to prevent users from copying the sheets to a new workbook and saving that? Gord Dibben MS Excel MVP On Fri, 28 Mar 2008 13:25:01 -0700, Tom Hutchins wrote: The Workbook_BeforeClose function has a Cancel argument. If your error handler sets this argument to True, the close operation should stop, leaving the workbook open. Hope this helps, Hutch " wrote: Hi, I have disabled the SAVE AS on my sheet, so users will not be able to save documents on their personal folder. I am having trouble dealing with closing the workbook and saving. I am using the workbooks_beforeclose function and ActiveWorkbook.close Save=true or something like that (cant remember th ecorrect syntax). It works fine, but only if there is enough disk space. We have limited disk space. I tried to catch the error with ON ERROR GOTO Errohandler: and at ERRORHANDLER: I do a check if the error is 1004 and display a message to warn users about it and then exit sub. The problem is that excel does not stop the closing process and it then asks if the user wants to save/discard or cancel the changes... Thats because after exit sub in the errorhandler, excell restarts the function again??? How can I avoid this? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks_beforeclose() function and out of disk space
Hi,
Good question. The sheets are locked and macros are necessary to function properly, if someone would copy the worksheet to a different workbook it would be useless. But your question raises another one more important, what if the user in explorer copies the file to a different name and uses it? I guess I will need to check the filename afterall. hmmm On Mar 28, 5:36*pm, Gord Dibben <gorddibbATshawDOTca wrote: Hammer I have disabled the SAVE AS *on my sheet, so users will not be able to save documents on their personal folder. What means have employed to prevent users from copying the sheets to a new workbook and saving that? Gord Dibben *MS Excel MVP On Fri, 28 Mar 2008 13:25:01 -0700, Tom Hutchins wrote: The Workbook_BeforeClose function has a Cancel argument. If your error handler sets this argument to True, the close operation should stop, leaving the workbook open. Hope this helps, Hutch " wrote: Hi, I have disabled the SAVE AS *on my sheet, so users will not be able to save documents on their personal folder. I am having trouble dealing with closing the workbook and saving. I am using the workbooks_beforeclose function and ActiveWorkbook.close Save=true or something like that (cant remember th ecorrect syntax). It works fine, but only if there is enough disk space. We have limited disk space. I tried to catch the error with ON ERROR GOTO Errohandler: and at ERRORHANDLER: I do a check if the error is 1004 and display a message to warn users about it and then exit sub. The problem is that excel does not stop the closing process and it then asks if the user wants to save/discard or cancel the changes... Thats because after exit sub in the errorhandler, excell restarts the function again??? How can I avoid this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save a file to disk without re-formating the disk | Excel Discussion (Misc queries) | |||
Getting Amount Free Disk Space On A Drive | Excel Discussion (Misc queries) | |||
Free disk space chart in Excel | Charts and Charting in Excel | |||
Any Tricks to decreasing Workbook size (disk space usage)? | Excel Discussion (Misc queries) | |||
Download files from 3.5 disk in excel but system said disk need fo | Excel Discussion (Misc queries) |