VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

**cychua** · 05-12-2013, 08:12 AM

Hello XL Guru,
I got no idea why my new work book not working. While the old workbook i used the same code is doing fine but not this.

Please Login or Register  to view this content.

When i test run on the macro, it kept showing message as titled mentioned above.
Greatly appreciated, if any1 would point out where my mistake is.

I understand that macro could not run on a protected sheets. After google for hours, i found this userinterface thingy, still no luck.

**Andy Pope** · 05-12-2013, 08:22 AM

if the workbook being saved contains code you need file format xlOpenXMLWorkbookMacroEnabled

**cychua** · 05-12-2013, 08:27 AM

Thanks for your reply, Andy.

Tried that too, when i google around last 2 hours ago.
Window, pop out the message as " This extension can not be used with the selected file type. Change the file extension in the file name text......."

**Andy Pope** · 05-12-2013, 08:28 AM

the extension you are using is "xlsx" which needs to be "xlsm"

**cychua** · 05-12-2013, 08:30 AM

Same there. I am okay with it, if my new saved file is macro-enable or not.

Before i come to board, i switch from .xslm and xslx. But both no luck.

**cychua** · 05-12-2013, 08:33 AM

I even un-protect all of my 14 sheets and test it to run again. But still the same.

**Andy Pope** · 05-12-2013, 08:35 AM

This worked for me. Note I changed save path.

Please Login or Register  to view this content.

Also you Workbook_Open code should be in the Thisworkbook object if you want it to execute on openning.

**cychua** · 05-12-2013, 08:39 AM

You mean this below?

Please Login or Register  to view this content.

Sorry to tell you. All of the code is i get help at excelforum and google.
I understand partially from your replied above. But not really get it what object to change or something. Very sorry on this, i am a nut in VBA.

**Andy Pope** · 05-12-2013, 08:42 AM

currently that code is in a standard code module. It needs to be in the Thisworkbook code module.

in VBE (ALT+F11)
in project view (F4)
you should see Thisworkbook listed within Microsoft Excel Object for that VB Project

Cut and paste the code in there. Then next time the workbook is opened the Open event will fire and the code will be run

**cychua** · 05-12-2013, 08:49 AM

Excelobject.png

You mean "Thisworkbook" suppose to be listed on the left circled area?

**Andy Pope** · 05-12-2013, 08:53 AM

like this

922380.png

**cychua** · 05-12-2013, 08:53 AM

Ok, got it now. Partially okay on my code for now. Just that my saved file name does not work as coded.

Hold a sec., need to get rid of that.

**cychua** · 05-12-2013, 09:13 AM

Hi Andy, all set and good to go.
Just that, i understand if i have another query, i should post a new thread again. If it is convenience for you, hope that you are able to advise me a little.

Sheet(1) cell H1 is my reference number and newly saved file name.
Is it possible to make exception on the below code, not to clear the contents on H1, so that another code of mine to +1 on the value is workable.

Code - Clear Contents

Please Login or Register  to view this content.

Code +1 on H1

Please Login or Register  to view this content.

**Andy Pope** · 05-13-2013, 03:58 AM

Why not store the content in a variable, just before clearing the sheet, and write it back out after clearing the sheet.

VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

LinkBack

Thread Tools

Rate This Thread

Display

VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

Re: VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

Re: VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

Re: VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

Re: VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

Re: VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

Re: VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

Re: VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

Re: VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

Re: VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

Re: VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

Re: VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

Re: VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

Re: VB Projects and XLM Sheets cannot be saved in a macro-free workbook.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions