Software

Ask something
Discussion Locked

Unshare a shared workbook

0 helpful
3 replies

by xplan_nation

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I've created a master file for multi users where I've done a lot of conditional formatting, drop down menues and locked sensible cells containing formulas. The moment I thought I was done test driving it, I said to myself I should make it shared. Now, after further testing I realized I needed to unlock some cells to do some tweaking, however I don't seem tofind an option or any kind of indication as to how to unshare the workbook so I could unlock the cells. Anybody has an idea I'd mostly apreciate that?

3 replies

by rroylance

I shared a workbook and then unshared it by the following method;

Go to tools then click on Share Workbook, this should produce a Share Workbook options box, in this box uncheck the Allow changes by more than one user at the same time. Click OK

This will produce another dialog box which allows for either a Yes or No answer, click yes and that should reset the workbook to normal operations.

Be sure to read the information in the dialog box before resetting the file.

Hope this works for you.

by atul.sharma

can any one tell me how can i share work book with macro. i very well know the proceedure how to share a workbook. but my macro create an excel sheet and automatically i want it should be shareable with the help of macro codes.

by deepsand

Try the "Questions" forum; the "Discussion" forum is for matters of general discussion, not specific problems in search of a solution.

Post problems such as this to the "Question" forum, rather than the "Discussion" forum. There are those who specifically seek out problems in need of a solution, and that's where they go to look for such.

Additionally there are the benefits that:

1) The "Questions" forum provides for your feedback, by way of your being able to mark "helpful" responses as such. This does not necessarily mean that a given response contained the complete solution to your problem, but only that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours, so that they might have a ready source of reference available, thereby perhaps obviating the need for them to repeat questions previously asked and answered.

2) The revised TR makes it quite difficult to find both "Discussions" and "Questions" that have not had a fairly recent post, owing to some functions comingling them in the listings. By keeping each type in their respective forums, it is easier for all to find what they are looking for.

This discussion is closed to new replies.