M
mbf
I have a fairly complex form split across 5 pages on a multipage control in
excel (Office 2003). It's a survey entry form so it's mostly grouped radio
buttons within invisible frames, labels and textboxes. The only addin I've
used is the MsForms Date Control.
If I leave VBE open for a while (anywhere between 15 mins and a few hours) a
path/file access error dialog is waiting for me when I get back. I dismiss
several of these followed by "an unexpected error has occurred. autosave has
been disabled for this session". Then I can't save the workbook any more.
The file is stored on a local drive which has no other problems. All other
apps work fine. I've downloaded all the office updates available.
I can export modules and class modules to reimport later, but I can't export
the form (or copy/paste it or any of the controls on it). Unfortunately this
happens several times a day and I'm trying to finish designing the form and
each time this happens I lose a lot of time.
I usually have Word 2003 open at the same time, but the error has happened
while it was not open.
I'm guessing it has something to do with the multipage control. I've worked
on other forms with many more controls but without the multipage with no
problems.
Should I disable autosave and see if that fixes the problem or is there some
known workaround for the problem?
excel (Office 2003). It's a survey entry form so it's mostly grouped radio
buttons within invisible frames, labels and textboxes. The only addin I've
used is the MsForms Date Control.
If I leave VBE open for a while (anywhere between 15 mins and a few hours) a
path/file access error dialog is waiting for me when I get back. I dismiss
several of these followed by "an unexpected error has occurred. autosave has
been disabled for this session". Then I can't save the workbook any more.
The file is stored on a local drive which has no other problems. All other
apps work fine. I've downloaded all the office updates available.
I can export modules and class modules to reimport later, but I can't export
the form (or copy/paste it or any of the controls on it). Unfortunately this
happens several times a day and I'm trying to finish designing the form and
each time this happens I lose a lot of time.
I usually have Word 2003 open at the same time, but the error has happened
while it was not open.
I'm guessing it has something to do with the multipage control. I've worked
on other forms with many more controls but without the multipage with no
problems.
Should I disable autosave and see if that fixes the problem or is there some
known workaround for the problem?