|reply to H2OuUp2 |
Re: [Excel] Updating Form buttons
Trouble is the worksheet is huge and contains a lot of proprietary data...by the time I stripped all that out it would be hard to replicate it.
I think I've sussed it. I have put the control sources for the buttons in one sheet, and I look them up in another. It allows users to sort the second sheet without screwing up all the control sources (SO stupid that they don't follow within VB when they move, but never mind).
I had the Worksheet change event on the second sheet and it appears that a change in a formula is not enough to trigger it - I've put the code on the sheet with the sources now and it seems to work fine.
The code seems to make Excel unresponsive if I edit the source sheet without having the form open. Does anyone know a quick "IF" test that will check if the form is loaded and skip the code if it's not?