Excel form (97)

[Allison]

I have an Excel form with various buttons, some of which only appear when a front button is pressed. I now wish to add some more 'hidden' buttons. The problem is that when I add extra command buttons, they won't become invisible - even though the visible property is set to 'false' and even more strangely, whatever the visible property is set to on the new button becomes the visible property on one of the existing buttons. - What am I doing wrong?

[pieterse]

Maybe you have indeliberately created buttons with the same names (dunno if that is even possible, but who knows...)?

[LegareColeman]

Did you create the new button by duplicating and existing button and end up with two buttons with the same name?

[Allison]

No, I did copy a button that works,then pasted and changed the name of the the problem button, but I have also created a new button from scratch - with the same result!

[pieterse]

Could you attach the file to a message here? (not when its big <g>).

[Allison]

Attached is the file - I have had to modify it to remove the data to make the file small enough to send. Pressing the large button should have make all 6 buttons visible, but as you can see, 4 of the buttons are visible anyway!

Thanks
Allison

[pieterse]

I am not sure what goes wrong. What I do see, is that your code seems to refer to a non-existent sheet, XL errors out on:

Sheets("Delayed transfer of care").Select

Maybe that has something to do with it?

[Allison]

The sheet 'Delayed Transfers of Care' is one of the sheets that I deleted to get the file small enough to send - the button for that is fine!

Allison

[Andrew Cronnolly]

Allison,

It seems to me that some corruption has crept into the workbook. I think you best bet is to re-create that sheet together with controls in a new workbook. You should be able to copy and paste the code behind the existing sheet and just add the controls and rename them to suit your code. If everything works as want when you switch out of design mode you can try moving the new sheet to the old workbook and see if it works.

Andrew C

[Allison]

Thanks - I'll give that a go!
Allison