hi there,
I was just wondering if the below command works for disable Form control buttons on active worksheet,
ActiveSheet.Buttons("Button 1").Enabled=False
Thanks.
hi there,
I was just wondering if the below command works for disable Form control buttons on active worksheet,
ActiveSheet.Buttons("Button 1").Enabled=False
Thanks.
No, it doesn't as you are presumably already aware!
Remember what the dormouse said
Feed your head
Oh thanks for that...
Now, is there a work around to disable Form Control on Active worksheet or do I just have to define the buttons as Active X controls...
Thanks.
You can use ActiveX controls instead, or hide the buttons that aren't usable, or add a check to the relevant macro that just informs the user it's not currently a valid option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks