Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 695
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting while sharing document SK Excel Discussion (Misc queries) 1 October 16th 07 04:58 PM
change excel document into word document mrsb Excel Discussion (Misc queries) 6 August 28th 07 12:58 PM
Urgent!!! Disable Sharing (File on FTP) FARAZ QURESHI Excel Discussion (Misc queries) 1 May 12th 07 10:21 AM
convert excel document to word document (not a picture) frendabrenda1 Excel Discussion (Misc queries) 2 October 6th 06 03:55 PM
How to create a formatted 'readable' document based on Excel document? [email protected] Excel Discussion (Misc queries) 0 June 23rd 06 06:09 PM


All times are GMT +1. The time now is 04:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"