Sigh - me again.
I thought I remembered how to do this; apparently not.
I have a button on a worksheet and I would like to change its properties using code in a userform command buttons Click event.
The name of the button on the worksheet is "ButtonSave" and I want to toggle its locked property - like this: ButtonSave.Locked=False. When I try this from the userform I get an error - Object required. I thought there was a fairly simple solution, but I'm having memory problems exacerbated by a lack of sleep, so I'm a little befuddled.
If there is an answer - cool. If not, I can fake it.
Happy eve',
Shawn
Bookmarks