I want to run macros on a share file but it is not working..
How do I do it?

What is "not working"?

Nothing? Errors?

You can normally run macros on a shared workbook.

You just can't access the code through VBE or see macros in the Macros
dialog..

Post your code.

Your code may be trying to do something not legal, like unprotect a
worksheet.


Gord Dibben MS Excel MVP


On Fri, 23 Oct 2009 07:24:01 -0700, Alberto Ast
wrote:

I want to run macros on a share file but it is not working..
How do I do it?

I am trying to unprotect a worksheet.. any way to get around this?

"Gord Dibben" wrote:

What is "not working"?

Nothing? Errors?

You can normally run macros on a shared workbook.

You just can't access the code through VBE or see macros in the Macros
dialog..

Post your code.

Your code may be trying to do something not legal, like unprotect a
worksheet.


Gord Dibben MS Excel MVP


On Fri, 23 Oct 2009 07:24:01 -0700, Alberto Ast
wrote:

I want to run macros on a share file but it is not working..
How do I do it?

.

None that I know of.

Type "shared" into help and click on "Features that are unavailable in
shared workbooks"

Has a list of unavailable features and some workarounds.

You will see that sheet protection cannot be changed.


Gord

On Fri, 23 Oct 2009 11:34:13 -0700, Alberto Ast
wrote:

I am trying to unprotect a worksheet.. any way to get around this?

"Gord Dibben" wrote:

What is "not working"?

Nothing? Errors?

You can normally run macros on a shared workbook.

You just can't access the code through VBE or see macros in the Macros
dialog..

Post your code.

Your code may be trying to do something not legal, like unprotect a
worksheet.


Gord Dibben MS Excel MVP


On Fri, 23 Oct 2009 07:24:01 -0700, Alberto Ast
wrote:

I want to run macros on a share file but it is not working..
How do I do it?

.