Thanks for your time & patience. I am trying to do what you are saying but
not reaching there - not yet. If I do have some important lessons learnt
then I will of course post it here, that is the least I can do to say thanks
to you for your patience.

"Dave Peterson" wrote:

I don't have a guess.

But you may want to consider rebuilding the workbook (including the modules and
userforms).



DKS wrote:

Operating system = Windows XP
Excel version = Excel 2003

Since I have been trying to play around with the VBA code around my
multipage forms, I get all kind of wierd errors. The most recent VBA error
that I got was
Run-time error '-2147024809 (80070057)' Could not get the picture property.

Some more extra info: I have put in my workbook_open event code to open the
form. But for whatever reason the form is not found.

Very frustrating indeed.

"Dave Peterson" wrote:

My question was:

What version of windows are you using?

What version of office are you using?

When you write that you moved to XP, did that mean that you moved to Windows XP
or Office XP (aka excel 2002)???

=====
If you add a multipage control to a userform, you can rightclick on the tab
(while designing the userform) and choose New Page.



DKS wrote:

I did not understand very well your last question.

I can imagine that different versions have different specialities and thus
is important to know. Nevertheless, here I am stuck with my own workbook
that worked well till the time I moved to XP. In XP also it works very well
but till the time I modify the multipage form. A simple change in the form
or even any VBA code lying behind it, and the entire workbook stops working.

As I was unable to figure out the problem's cause, I tried to redevelop a
simple prototype in xls 2003. MY idea was that by developping a simple
prototype I may hit upon the problem.

Nevertheless I am stuck as I do not find out any more how did i design 3
years ago a multipage form with 5 pages. When i design a new form, it gives
me 2 pages by default and I am struggling to figure out the trick I had done
to generate 5 pages.

"Dave Peterson" wrote:

Not that I didn't share already.

But the operating system and the version of office don't have to match. (Each
version of office does have a minimum version of windows that must be installed,
though.)

If you get other followups, you may want to make it clear what version of each
you're running.

DKS wrote:

It was an NT machine, so I presumed it was 95. It could well have been 97.
Since I have migrated to XP - I do not have the previous machine to verify
the situation.

Nevertheless the symptoms are very frustrating. Not only does the form does
not work at all, it makes my .xls crash.

Any ideas?

best regards

"Dave Peterson" wrote:

Are you sure it worked in xl95?

I thought that userforms (inside the VBE) were added in xl97.

Maybe the workbook was really created in xl97 and you're saving it as an xl95
file format????


DKS wrote:

I had an .xls in Excel 95 that used multipage forms. This .xls and the forms
works fine in XP (Excel 2003) if I use it without any changes.

The moment I make even a single change in the form and use it, it still
works fine till the time I save the .xls and close .xls. Once I do this and
re-open the .xls and that is the end of my hardwork. It no longer seems to
work.

Can somebody help explain this behaviour? And ideally help solve this error.

Thanks in anticipation.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson