Shared Workbooks

[Gary Thomson]

Hi there,

Why does it say at the top of my workbook (in the title
bar) that the workbook is "Shared" - I cant get rid of
this???

It is stopping me recording a new Macro into "This
Workbook"...

Is there a Macro I can write which will allow me to print
off each sheet within the workbook, such that each sheet
is:

(i) Centred Horizontally;
(ii) Centred Vertically;
(iii) Fits to 1 page wide by 1 page tall;
(iv) Shows Row and Column headings;
(v) Has the Tab name of the worksheet in the centre of the
header, size 16 point Arial.

Many Thanks.

Gary.

 

[Anne Troy]

Go to Tools-->Share workbook and uncheck sharing.

You can record that macro. Here's how:
http://www.theofficeexperts.com/officevba.htm#ExcelVBA

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com

 

[Frank Kabel]

Hi Gary
to remove sharing goto the mneu 'Tools - Sharing' and remove the
sharing

 

[Guest]

Does anyone else use this document

Shared means that more than one person can edit it at one time
To make this an unshared document - ie locked to the first person that opens it ..
Select Tools - Share Workbook => dialog will appea
Remove the tick from the checkbox and press o

This means that when you have that file open, others will have to have it in read-only mode.