chem101
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.
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.