Code for Command Button - error message when other button not yet clicked

[Nadine1988]

Hello,

i do have a file with two command buttons.
Command Button 1 does check some fields and then save the file.
Command button 2 does send the saved file attached to an email.

I would now need a code that doesn't allow command button 2 to be pressed if the file wasn't saved (so if command button 1 wasn't pressed yet)
So the user has to save the file BEFORE submitting the form.

any ideas on how to set this up correctly? Thanks!
Nadine

 

[Nadine1988]

As you can see in the screenshot it's supposed to be a quote number / subject line - filled out by the sales team. i know it was A15 before but i did change the layout a little bit.

 

[Herakles]

As you can see in the screenshot it's supposed to be a quote number / subject line - filled out by the sales team. i know it was A15 before but i did change the layout a little bit.

So what value is your code using for the file name and where does this value come from?

Can you give me a file name example?

 

[Nadine1988]

For testing i'm only using "Test" but it can be literally everything - most probably a mix out of numbers and letters

So what value is your code using for the file name and where does this value come from?

Can you give me a file name example?f

 

[Herakles]

For testing i'm only using "Test" but it can be literally everything - most probably a mix out of numbers and letters

In a previous post you said:
The filename is supposed to come for cell A18 - but with your code it's not saving at all. and with my code it's saving with the wrong name.

Where is the data coming from that is making up the file name that you say is the wrong name?

 

[Nadine1988]

i found out what was wrong. i did change the file format but not in the whole code. it's working now.

so just one more error to fix and then I'm finally finished! THANK YOU ALL FOR YOUR SUPPORT!

 

[Nadine1988]

Just in case you wanna look into this too:

"Hello - i actually run into an other error with this.

so this is the code:

VBA Code:
Sub Optionsfeld38_BeiKlick()
Sheet1.Unprotect Password:="Vizrt"

If Optionsfeld38 = False Then
Rows("15:16").EntireRow.Hidden = Not Rows("15:16").EntireRow.Hidden
End If

Sheet1.Protect Password:="Vizrt"

End Sub
Sub Optionsfeld39_BeiKlick()
Sheet1.Unprotect Password:="Vizrt"

Rows("15:16").EntireRow.Hidden = False

Sheet1.Protect Password:="Vizrt"
End Sub

So it actually hides the rows when clicking the "No" optionbutton but the problem with this is that rows 15:16 all of a sudden appear as soon as i move forward with entering data into the rest of the form. any ideas what's wrong here?

Thank you!"