Stop CustomSave VBA if disk is full and file cannot be saved

Hi all,

I am using a custom "save" and "save as" routine, which works fine most of the time. Unfortunately, sometimes the shared drive is full and the saving is interrupted. Can I somehow stop the

Please Login or Register  to view this content.

if that happens? and show a message that saving wasn't successfull??

Please Login or Register  to view this content.

Hi,

You did not mention an error that you received from attempting to save the file to a full shared drive. Processing this error and then unhiding the sheets you hid is probably the easiest thing to do (if possible).

Otherwise, see the following thread, which has functions that return the amount of free disk space on a 'shared drive'. You have to determine ahead of time how much disk space you need.
https://www.mrexcel.com/forum/excel-...ive-space.html

Lewis

The error I get when the shared drive is full, is the following:

error_diskspace.PNG

Then, as the saving routine is interrupted, my code goes into "Debug" mode once I click "OK"

savinginterrupted.PNG

And when I click "Debug" it highlights the "Me.Save" line.

savingdebug.PNG