Hi,
I have a button with a code which saves a sheet as a PDF when clicked. I also have two option buttons (Option Button 20 and Option Button 21) on the same sheet. If one is toggled the other is not toggled and vice versa. What I would like to do is on the same 'Save as PDF' code I have already, insert some additional code to the existing save as pdf code which will do the following:
BEFORE the save PDF bit of code:
Toggle Option Button 20 ONLY IF Option Button 21 is already toggled.
Keep Option Button 20 toggled if it is toggled already.
AFTER the save PDF bit of code:
Toggle Option Button 21 again ONLY IF Option Button 21 was toggled beforehand.
Keep Option Button 20 toggled if it is toggled already.
I essentially only want the save PDF bit of code to run if Option Button 20 is selected. It should temporarily force Option Button 20 into selection during the code run in the event that Option Button 21 is selected beforehand.
I have tried so many codes I've found on Google but nothing works, I keep getting error 438 object does not support this property or method. Any help most appreciated. They are FORM CONTROL BUTTONS not ActiveX.
I have a button with a code which saves a sheet as a PDF when clicked. I also have two option buttons (Option Button 20 and Option Button 21) on the same sheet. If one is toggled the other is not toggled and vice versa. What I would like to do is on the same 'Save as PDF' code I have already, insert some additional code to the existing save as pdf code which will do the following:
BEFORE the save PDF bit of code:
Toggle Option Button 20 ONLY IF Option Button 21 is already toggled.
Keep Option Button 20 toggled if it is toggled already.
AFTER the save PDF bit of code:
Toggle Option Button 21 again ONLY IF Option Button 21 was toggled beforehand.
Keep Option Button 20 toggled if it is toggled already.
I essentially only want the save PDF bit of code to run if Option Button 20 is selected. It should temporarily force Option Button 20 into selection during the code run in the event that Option Button 21 is selected beforehand.
I have tried so many codes I've found on Google but nothing works, I keep getting error 438 object does not support this property or method. Any help most appreciated. They are FORM CONTROL BUTTONS not ActiveX.