Save a copy of workbook without macros

**nnram123** · 05-19-2009, 07:03 AM

Hi,

I have an excel file with macros. I want to make a copy of this file without macro. Kindly provide your suggestions. (I have too many objects and more formatting in the workbook. It should not get affected while making another copy of this workbook.)

Thanks,
Ram

**royUK** · 05-19-2009, 07:09 AM

The easiest way is to place the code into an Excel addin, then no code is necessary in the worbook

**nnram123** · 05-19-2009, 07:12 AM

That we can't do. Since it is working as a client side application.

**royUK** · 05-19-2009, 07:15 AM

Then the client could install the addin. You can remove all code with VBA, but the VBA project cannot be protected, is this an option?

**nnram123** · 05-19-2009, 07:19 AM

How to remove all the codes which are written in VBA for that workbook?

Thanks,
Ram

**royUK** · 05-19-2009, 07:45 AM

read this, but remember yo cannot use it on a workbook that contains a protected VBA project.

Save a copy of workbook without macros

LinkBack

Thread Tools

Rate This Thread

Display

Save a copy of workbook without macros

Re: Save a copy of workbook without macros

Re: Save a copy of workbook without macros

Re: Save a copy of workbook without macros

Re: Save a copy of workbook without macros

Re: Save a copy of workbook without macros

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions