WebJul 23, 2024 · I get get a pop-up warning that VB projects cannot be saved in macro-free workbooks. I answer "NO" to continuing macro-free, then click save. Instead of saving, the pop-up warning returns. It keeps repeating, never saves. Can anybody offer a solution? Thanks. You must save it as file type:-. .xlsm. - being an Excel Macro-Enabled Workbook. WebMar 25, 2024 · I have tried to copy some Excel macro-enabled workbooks from my laptop to my desktop. Every which way. I can manually create a new .xlsm by adding some VBA and saving as .xlsm, but I cannot download the .xlsm (OneDrive or Google Drive) or import project files (.bas, .frm, etc.) to a .xlsx and then save as .xlsm.
Vba code to save a worksheet as normal excel worksheet (without macros ...
WebApr 10, 2024 · Save your file to couple different location: How mentioned above, Excel won’t save your file due to an insufficient amount of space in your disk, antivirus conflict with the excel file or if your document names exceeds the maximum personality limit. In such cases, it a advisable until displace your date to some other location. WebMay 28, 2024 · As per your description, it seems issue only happened on Excel VBA “.xlsm” file when save on OneDrive for business. Generally, .xlsm files can be AutoSaved to OneDrive. How about if you save macro file via after starting Excel, click on File > Options>Save, and set “Save files in this format” as “.xlsm”. pick up truck two door
Change macro security settings in Excel - Microsoft Support
WebJan 31, 2024 · 2. Opening the excel file in safe mode. Hit on the Windows+R key, button then type 'excel.exe/safe and click OK. Open your Excel file in Safe mode, then save your file as .xlsx. 3. Disable automatic calculation. Open excel and tap on the File tab; Press the Options item in the menu on the left WebExport Active Sheet as PDF File. The following macro code will export the active sheet (or selected sheets) in PDF format. Printing the code the a regular code module, then select … WebFeb 26, 2024 · Feb 22, 2024. #1. Hi my workbook macros have all gone and file wont save as it says it has errors. I do have a backup, but this is happening every day now. backup works fine,until it is updated with a few rows of data, i dont believe the workbook has any errors. This is a snap shot of modules, where i cant click anything. pickup truck trailer brake controller