Workbook crashes excel when a macro is performed.

[Phixtit]

Something crashes my workbook in excel.
It works fine with 32-bit Excel.
It crashes with a 64-bit Excel.
It only crashes if I click MENU & then DAY (2 to 30) or ADD A DAY & then when I DELETE A DAY it crashes.

I've attached my workbook for download so someone could please narrow the problem down. Thanks.
If you need the Password, it is: 1212

Any ideas?

[snb]

Please Login or Register  to view this content.

[romperstomper]

Just to perhaps save others some time, if you aren't using a 64bit OS the sample workbook will not work!

[Phixtit]

Please Login or Register  to view this content.

I have tried your suggestion but it still crashes.

Just to perhaps save others some time, if you aren't using a 64bit OS the sample workbook will not work!

Sorry, I have edited my 1st post & have attached both versions 32 and 64bit versions.

[romperstomper]

If it hasn't been fixed before then, I'll take a look at it tomorrow morning. Done too much Excel stuff today.

[romperstomper]

I ran Code Cleaner on your workbook (it was behaving a little oddly) and it seemed fine after that.

[Phixtit]

I ran Code Cleaner on your workbook (it was behaving a little oddly) and it seemed fine after that.

So what should I change in the code to stop the crash?
What is code cleaner?

[romperstomper]

It's an add-in: http://www.appspro.com/Utilities/CodeCleaner.htm
Try it and see (it basically cleans out all the crap p-code that builds up behind the scenes when you edit code)

[Phixtit]

It's an add-in: http://www.appspro.com/Utilities/CodeCleaner.htm
Try it and see (it basically cleans out all the crap p-code that builds up behind the scenes when you edit code)

I've done as you suggested and updated my 1st post in this thread with the cleaned workbook.

It works fine with Excel 32 bit.
ONLY problem is it crashes with Excel 64-bit.
It only crashes if I click MENU & then DAY (2 to 30) or ADD A DAY & then when I DELETE A DAY it crashes.

Any ideas?

[romperstomper]

Did you clean both versions?

[Phixtit]

The VBA Code Cleaner doesn't work with Excel 64-bit so I cleaned it on another computer with 32-bit & added the PtrSafe so it works with both 32-bit & 64-bit and edited the 1st post attachment in this thread.

[Phixtit]

*Bump*

Any ideas?

[Phixtit]

Did you clean both versions?

Any ideas?

[romperstomper]

Could you post the cleaned 64 bit version please?
I don't always have access to my 64 bit machine so it takes time.

[snb]

Maybe

Please Login or Register  to view this content.

[Phixtit]

Could you post the cleaned 64 bit version please?
I don't always have access to my 64 bit machine so it takes time.

I did, it's the attachment in the 1st post.
Opens with 32 & 64-bit

[romperstomper]

Ah, I missed that. I'll take a look when I get a chance.

[romperstomper]

Just had a chance to take a look at this in XL64 and I can replicate but only if you delete the sheet that you called the form from, which doesn't surprise me particularly (since there is code running in that sheet when you delete it).

[Phixtit]

So, why does it work flawlessly on 32-bit? Any suggestions on what I could do to solve this issue with 64-bit?

[romperstomper]

A bug in 32 bit?
I'll have another look tomorrow (I try to avoid excel stuff at weekends)

[romperstomper]

Personally, I would void using buttons on the sheets and go with a menu system, but for a quick fix it seems to work if you use OnTime to load the form:

Please Login or Register  to view this content.

I'd also suggest you could streamline your code to add the day sheets by making it into one routine that takes a day number as an argument, and then call it from each button.