ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I disable sharing on Excel document? (https://www.excelbanter.com/excel-discussion-misc-queries/252110-how-do-i-disable-sharing-excel-document.html)

Mike M

How do I disable sharing on Excel document?
 
I have a document shared. I need to record a macro and apply validation to
cells on the sheet. I must first disable sharing but just can't seem to find
it.

excelent

How do I disable sharing on Excel document?
 
Same way as u share it
then remowe checkmark

"Mike M" skrev:

I have a document shared. I need to record a macro and apply validation to
cells on the sheet. I must first disable sharing but just can't seem to find
it.


trip_to_tokyo[_3_]

How do I disable sharing on Excel document?
 
In EXCEL 2007 take the following action:-

Review

Changes group

Share Workbook

Remove the tick from the box called:-

Allow changes by more than one user at the same time. This also allows
workbook merging.

Hit OK.

If my comments have helped please hit Yes.











"Mike M" wrote:

I have a document shared. I need to record a macro and apply validation to
cells on the sheet. I must first disable sharing but just can't seem to find
it.



All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com