Is Ctrl + S and ThisWorkbook.Save the same?

[trimmjens]

Hi,

I'm trying to find out if there is any difference between ways of saving a workbook.

I have a userform that pops up before saving the workbook.

If I save the workbook using the save button, press Ctrl + S or use SendKeys("^"&"s") it is no problem.
But if I use ThisWorkbook.Save or ActiveWorkbook.Save the userform is not behaving the way it is supposed to.

How are there methods different?

Appreciate all answers.

-Thomas

 

[mole999]

what occurs with the activeworkbook.save that is different

 

[trimmjens]

The userform has a progressbar with max value that equals Sheets.Count. The code protects each sheet one by one and adds 1 to the progressbar for each sheets. (For loop)
The Userform_Activate (where my protect code is) will not run if I use the ActiveWorkbook.Save method.

 

[mole999]

could you not call the

sub something
.....
Userform_Activate
ActiveWorkbook.Save
...
exit sub

 

[trimmjens]

Thank you for your time. I undertand your suggestion.
The problem is that I run the userform BeforeSave and the same userform AfterSave with different actions.

When I save the workbook the userform does some actions prior to saving the workbook and other actions after save.
I set a variable to decide which actions to run from Userform_Activate.