Hidden Macro

[peebar]

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]

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.)

 

[Guest]

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.

 

[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.

 

[Peebar]

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.





--

Dave Peterson
(e-mail address removed)
.