Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to avoid user to save in .xlsx
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to avoid user to save in .xlsx
On Jul 26, 1:06*pm, Mathieu936 wrote:
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to avoid user to save in .xlsx
On 26 juil, 20:03, Don Guillett Excel MVP
wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to avoid user to save in .xlsx
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" skrev i en meddelelse ... On 26 juil, 20:03, Don Guillett Excel MVP wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want Macro to save to .xlsx | Excel Programming | |||
save xlsx files | Excel Programming | |||
Unable to save XLSX files without using 'Save As' and different na | Setting up and Configuration of Excel | |||
How to default file save format to .xlsx in Excel? | Excel Discussion (Misc queries) | |||
Save Workbook As .xlsx to Remove Macros? | Excel Programming |