View Full Version : Solved: Disable Form Control Button/Code

02-16-2011, 09:36 AM
Hello Everyone,
I have a worksheet with about 10 Form Control Buttons. The UI is limited as I have disable the ribbon and sheet tabs. One of the buttons saves the users input. Another button allows the user to retrieve a saved file for further updating. I have two other buttons that I would like to disable when a saved file is retrieved. Is it possible to disable these button or corresponding code when a saved file is retrieved? Or should I convert these Form Control Buttons to Active X Command Buttons and disable the code this way? Any help you can provide will be greatly appreciated.

Thank you.

Bob Phillips
02-16-2011, 12:03 PM
ActiveSheet.Buttons("Button 1").Enabled = False

02-16-2011, 02:22 PM
Thank you very much! You're Great!