Mazesj
05-21-2020, 12:56 AM
Hi,
I am trying to develop a code to assist with an approval process flow. The spreadsheet is standard and users have certain fields to populate. The sheet has three Active X buttons (Send for Approval, Approved, Declined). However, both the Approved and Declined are disabled for the initial process.
1.The 'Send for Approval' button is pressed and the excel worksheet is attached to an outlook email.
2.The recipient of the email will open the attachment, the 'Send for Approval' button will be disabled and the 'Approved' and 'Declined' button enabled.
3.That person should be able to press either 'Approved' or 'Declined' and this then returns an email to the original sender stating which button was pressed.
I've tried but i was unsuccessful. Looking for a code that can help with this. The excel sheet has been attached to this post for visual representation.
I am trying to develop a code to assist with an approval process flow. The spreadsheet is standard and users have certain fields to populate. The sheet has three Active X buttons (Send for Approval, Approved, Declined). However, both the Approved and Declined are disabled for the initial process.
1.The 'Send for Approval' button is pressed and the excel worksheet is attached to an outlook email.
2.The recipient of the email will open the attachment, the 'Send for Approval' button will be disabled and the 'Approved' and 'Declined' button enabled.
3.That person should be able to press either 'Approved' or 'Declined' and this then returns an email to the original sender stating which button was pressed.
I've tried but i was unsuccessful. Looking for a code that can help with this. The excel sheet has been attached to this post for visual representation.