how to avoid user to save in .xlsx

[Mathieu936]

Hi!

I have an add-in (.xlam) which copies a worksheet (which contains a
Sub worksheet_calculate) in the current workbook.

However, if the current workbook is an .xlsx format, and the user
still saves in .xlsx format (regardless the message box saying that
the macro will be deleted), the new inserted worksheet will lost its
Sub worksheet_calculate.

I really need to keep the Sub worksheet_calculate.

Is there any code/fonction/way to avoid that the used save in .xlsx?
The current workbook can be an existing file with .xlsx format, or a
new freshly created workbook.

Thanks!

 

[Don Guillett Excel MVP]

Hi!

I have an add-in (.xlam) which copies a worksheet (which contains a
Sub worksheet_calculate) in the current workbook.

However, if the current workbook is an .xlsx format, and the user
still saves in .xlsx format (regardless the message box saying that
the macro will be deleted), the new inserted worksheet will lost its
Sub worksheet_calculate.

I really need to keep the Sub worksheet_calculate.

Is there any code/fonction/way to avoid that the used save in .xlsx?
The current workbook can be an existing file with .xlsx format, or a
new freshly created workbook.

Thanks!

Look in the ThisWorkbook module for before save and stop it within
that.

 

[Mathieu936]

Look in the ThisWorkbook module for before save and stop it within
that.- Masquer le texte des messages précédents -

I tried it but the BeforeSave event happens before saving. So I could
popup a message box saying to not save in .xlsx, but after user could
save in .xlsx which is bad.

 

[Charlotte E]

You could make the 'BeforeSave' event force-save the workbook as .XLSm, set
Cancel = True after the saving is done, and perhaps let a MsgBox inform the
user that the workbook was saved as .XLSm instead of .XLSx

CE



"Mathieu936" <[email protected]> skrev i en meddelelse

Look in the ThisWorkbook module for before save and stop it within
that.- Masquer le texte des messages précédents -

I tried it but the BeforeSave event happens before saving. So I could
popup a message box saying to not save in .xlsx, but after user could
save in .xlsx which is bad.