At its bottom, once displayed, go to the box button for Excel Options. If I select yes to save as a macro free file the code finishes and works fine. up vote 2 down vote favorite Every time when I try to save a file, I'm getting the following error message. The low setting opens workbooks with code without any warnings. this content
However, despite the fact that the file being opened is .xlsm, upon workbook.save I get the alert message "the following features cannot be saved in macro-free workbooks..." This doesn't make sense Also, set the show developer tab and trust addins, for full access. Alex Cantu 6,814 views 2:26 Excel 2013 Tutorial 19: Intro to Macros - Duration: 9:32. 10minutetrain 31,745 views 9:32 How to install XAMPP Control Panel v3.2.1 on Windows 10 - Duration: The system returned: (22) Invalid argument The remote host or network may be down.
Sign in to add this to Watch Later Add to Loading playlists... Rating is available when the video has been rented. Copyright © 2004 - VBA Express current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Register Help Remember Me? Portal Forum FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders Knowledgebase Articles Blogs Resources Consulting Services Training PayPal Donation Advanced Search Forum
In the Save As dialog box select "Excel-Macro Enabled Workbook" Alternatively, you can change the way the default way Excel saves the file. For a list of valid choices, see the FileFormat property. It looks as if I need to add another line of code that confirms that the file is indeed supposed to be .xls, but where and how do I do this? The Following Features Cannot Be Saved In Macro-free Workbooks Excel 4.0 Function In 2007 this is available from the upper Right Option Icon, the one that displays the print and save options!
tutorbeta 57,934 views 7:05 Excel Worksheet Events #2 Macro when you change a cells value, LEFT and UCASE functions - Duration: 8:25. The Following Features Cannot Be Saved In Macro-free Workbooks Disabled To continue saving as a macro-free workbook, Click Yes" I want the excel file saved with the macros but without this notification. Register To Reply 07-15-2010,06:02 PM #7 shg View Profile View Forum Posts Forum Guru Join Date 06-21-2007 Location The Great State of Texas MS-Off Ver 2003, 2010 Posts 36,835 Re: vb This feature is not available right now.
I ensured there is no content in VBA editor for the file I'm trying to save. (No other files opened) The default save format in excel option is set to Excel Excel 4.0 Function Stored In Defined Names How to capture disk usage percentage of a partition as an integer? Youâ€™ll be auto redirected in 1 second. C# TBB updating metadata value In the context of this quote, how many 'chips/sockets' do personal computers contain?
Register To Reply 07-15-2010,05:37 PM #4 2funny4words View Profile View Forum Posts Forum Contributor Join Date 01-05-2009 Location South Dakota, USA MS-Off Ver 2003, and 2007 Posts 148 Re: vb project Now all your file will be saved as xlsm by default unless you change it manually. Macro Free Workbook Excel 2013 Not so sure about this one though - it's on the left in my version. What Does Macro Free Workbook Mean SHG, I googled your comment and learned?
Any ideas? Thanks, vanhunk Reply With Quote 09-08-2014,01:52 AM #5 SamT View Profile View Forum Posts View Blog Entries View Articles Moderator VBAX Guru Joined Oct 2006 Location Near Columbia Posts 4,931 Location But you'd better use an algoritm to produce a filename that doesn't exist, so the user won't be bothered with tasks that can better be automated. have a peek at these guys Loading...
Hot Network Questions How to handle swear words in quote / transcription? The Following Cannot Be Saved In A Macro-free Document Vba Project Attached Files Copy of Report Form dummy.zip (390.1 KB, 52 views) Download Last edited by 2funny4words; 07-16-2010 at 12:58 AM. ExcelIsFun 99,351 views 8:21 Excel Userform Login - Multi - Level User Login - Duration: 14:07.
You need to go into each system that will be ruining your application and change the macro security and go into trusted sources and check the box for access to the Safety - Improve braking power in wet conditions Find a mistake in the following bogus proof MathSciNet review alert? Not the answer you're looking for? Excel Macro-enabled Workbook Look here - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker - Read: Forum Rules & Forum Use Guidelines
Last edited by snb; 09-08-2014 at 02:30 AM. Show more Language: English Content location: United States Restricted Mode: Off History Help Loading... Understanding model independently the equivalence of two ways of obtaining homotopy types from categories. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Nov 2nd, 2011,11:14 AM #9 kstvns New Member Join Date Feb 2011 Posts 20 Re: Macro-Free workbook Error Originally
I do not answer questions by email unless I get paid for it :) If you want, create a thread in VB.Net/Excel forum and email me the link and I will L4RRY 17,037 views 4:46 Creating a Macro Buttons for Printing of a worksheet Sheet - Duration: 2:53. To start viewing messages, select the forum that you want to visit from the selection below. Reply With Quote 09-08-2014,02:13 AM #7 vanhunk View Profile View Forum Posts View Blog Entries View Articles VBAX Contributor Joined Jun 2012 Posts 197 Location Thank you SamT & snb I
Please try the request again. Previous examples of large scale protests after Presidential elections in US? I am using excel 2007 but in compatability mode, (since the computer that the end users work with are all 2003). E- CamICT 597 views 4:03 Excel Visual Basic (VBA) for Beginners - Part 1 of 4: Buttons and Macros - Duration: 6:49.
Join them; it only takes a minute: Sign up Workbook.save - “the following features cannot be saved in macro-free workbooks…” up vote 3 down vote favorite My sub opens up a excelblogger 16,571 views 10:20 How To Sum Cells by Background Colour in Office Excel - Duration: 4:46. Sign in 1 Loading... All rights reserved.
Is adding the â€˜tblâ€™ prefix to table names really a problem? Working...