Disappearing form buttons + sticking autofilter arrows

[akkido]

Hi all!
This is my first post, after googling and reading for hours and hours on the internet and forums like this on to get an answer to my question. A few months ago I started the challenge of making a simple caravan park booking sheet. in excel, with user forms and vba macro's to generate reports with current customers and also a calendar with for every type of accomodation information on if it is booked for a certain date. I have made a few buttons on one of the worksheets, which activate macro's and userforms. The macro's use the Autofilter function a lot.

This is my problem: After running a macro that generates the daysheets and other reports, sometimes (this is important, it does not happen every time and some days it does not happen at all) the buttons disappear (I have used both Control Toolbox Buttons and Form Toolbar button, both disappear). At the same time, and sometimes at a different time, the autofilter dropdown arrows stay visible, but have no function. Weird thing is that it does not always happen. In the vba code I use If Activesheet.autofilter Then Activesheet.Autofiltermode = False before the macro finishes.

I use Windows XP with Office XP (Excel 2002, SP 3).

I am staying ate the caravan park now so the disapperaing buttons is not a major problem - I keep making new ones But before I leave I'll have to have this problem fixed.

I am at a loss for what is happening here,
thanks for your help,
Akkido

Please forgive me for my probably amateurish use of excel-terms.

[royUK]

Can you attach a zipped workbook?

[akkido]

Hi Roy UK,
Here is a zipped workbook. I remove about 800 customers, to make the file smaller. I also had to remove some worksheets, to make the zip file smaller than 100 kB. But the 'generate macro is still there, just let it run for a few times and the problem should occur.

Thanks for your help!
Akkido

[akkido]

Hi Roy,
Could you make any sense out of my workbook?
Akkido

[royUK]

I couldn't replicate the problem

[akkido]

Hi Roy,
Could you please tell me what windows version you have, and which excel version and what the dimensions of your screen are? The problem might have something to do with those things, and nothing with the sheet itself.
Thank you,
Akkie