I am working on a shared workbook where I cannot edit the
macros. There is no menu option to unshare the workbook
nor to unprotect it. How do I get to edit the macros?

There wasn't a Tools|Share Workbook option on the worksheet menubar?

Does that option appear if you just start excel and start a new workbook?

(maybe the developer was trying to stop you from unsharing the workbook.)

peebar wrote:

I am working on a shared workbook where I cannot edit the
macros. There is no menu option to unshare the workbook
nor to unprotect it. How do I get to edit the macros?

--

Dave Peterson

Dave

the option does appear if I just start excel. I agree the
developer may have been trying to stop unsharing however
he did leave us with all his passwords etc...I just need
some means that will allow me to unshare and unprotect
that requires a password.

-----Original Message-----
There wasn't a Tools|Share Workbook option on the
worksheet menubar?

Does that option appear if you just start excel and start
a new workbook?

(maybe the developer was trying to stop you from
unsharing the workbook.)

peebar wrote:

I am working on a shared workbook where I cannot edit
the
macros. There is no menu option to unshare the workbook
nor to unprotect it. How do I get to edit the macros?

--

Dave Peterson

.

You may be able to reset that toolbar.

Tools|Customize|toolbars tab
click on worksheet menubar and then hit reset.

This will reset any other changes that you've made (or that developer made),
though.

And if the developer put a routine that changed that toolbar each time you open
the workbook, you'll either have to do this kind of thing or find his routine
and modify it.



wrote:

Dave

the option does appear if I just start excel. I agree the
developer may have been trying to stop unsharing however
he did leave us with all his passwords etc...I just need
some means that will allow me to unshare and unprotect
that requires a password.

-----Original Message-----
There wasn't a Tools|Share Workbook option on the
worksheet menubar?

Does that option appear if you just start excel and start
a new workbook?

(maybe the developer was trying to stop you from
unsharing the workbook.)

peebar wrote:

I am working on a shared workbook where I cannot edit
the
macros. There is no menu option to unshare the workbook
nor to unprotect it. How do I get to edit the macros?

--

Dave Peterson

.


--

Dave Peterson

Dave

It worked...thanks for all the help.
-----Original Message-----
You may be able to reset that toolbar.

Tools|Customize|toolbars tab
click on worksheet menubar and then hit reset.

This will reset any other changes that you've made (or
that developer made),
though.

And if the developer put a routine that changed that
toolbar each time you open
the workbook, you'll either have to do this kind of thing
or find his routine
and modify it.



wrote:

Dave

the option does appear if I just start excel. I agree
the
developer may have been trying to stop unsharing however
he did leave us with all his passwords etc...I just need
some means that will allow me to unshare and unprotect
that requires a password.

-----Original Message-----
There wasn't a Tools|Share Workbook option on the
worksheet menubar?

Does that option appear if you just start excel and
start
a new workbook?

(maybe the developer was trying to stop you from
unsharing the workbook.)

peebar wrote:

I am working on a shared workbook where I cannot edit
the
macros. There is no menu option to unshare the
workbook
nor to unprotect it. How do I get to edit the macros?

--

Dave Peterson

.


--

Dave Peterson

.