Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 183
Default how to proctect a workbook, then allow updates to be seen as read

I'm working on a work book that I want to be able to make updates to and
allow other people to open the file as "read Only" and see the changes I
made. I can't seem to get to work.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default how to proctect a workbook, then allow updates to be seen as read

Exactly what process are you going through right now that doesn't seem to be
working?

Try this - and watch the steps (from Excel 2003) closely because it's easy
to get lost. Use
File | Save As
In the dialog that comes up, look for a [Tools] pulldown at the TOP RIGHT of
the dialog box.
Open that list up and choose [General Options]
In the next window that opens you have the "Read-Only Recommended" option
available, and if you want to make sure that no one modifies it, enter a
password for the "Password to modify:" entry. Just don't tell anyone that
password, but write it down somewhere so you can modify your file later if
you need to.

Optionally, you can make a copy of your working file, and apply the
Read-Only and Password properties to the copy and make that available for
public viewing - keeping your original file in a pristine state without a
password needed to work with it.

"Sharon" wrote:

I'm working on a work book that I want to be able to make updates to and
allow other people to open the file as "read Only" and see the changes I
made. I can't seem to get to work.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 183
Default how to proctect a workbook, then allow updates to be seen as r

Thank you for your help. We actually discovered that some of the people's
computers were allowing them to see the changes and some weren't. The only
changes that were not appearing on some comp;uter were lines that were drawn
with the draw tool. We are going to change the way we do the lines so
everyone will see those changes.

Thank you again.

"JLatham" wrote:

Exactly what process are you going through right now that doesn't seem to be
working?

Try this - and watch the steps (from Excel 2003) closely because it's easy
to get lost. Use
File | Save As
In the dialog that comes up, look for a [Tools] pulldown at the TOP RIGHT of
the dialog box.
Open that list up and choose [General Options]
In the next window that opens you have the "Read-Only Recommended" option
available, and if you want to make sure that no one modifies it, enter a
password for the "Password to modify:" entry. Just don't tell anyone that
password, but write it down somewhere so you can modify your file later if
you need to.

Optionally, you can make a copy of your working file, and apply the
Read-Only and Password properties to the copy and make that available for
public viewing - keeping your original file in a pristine state without a
password needed to work with it.

"Sharon" wrote:

I'm working on a work book that I want to be able to make updates to and
allow other people to open the file as "read Only" and see the changes I
made. I can't seem to get to work.

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
Workbook updates Master Chief Excel Discussion (Misc queries) 1 August 11th 06 06:16 PM
Workbook updates smiths4 Excel Discussion (Misc queries) 1 May 18th 06 08:22 PM
Help with workbook updates Danno Excel Worksheet Functions 2 February 6th 06 11:56 PM
linked workbook updates sir Lancelot Excel Worksheet Functions 0 July 27th 05 05:10 AM
Trying again for workbook formula updates Paulie Excel Worksheet Functions 2 March 2nd 05 04:53 PM


All times are GMT +1. The time now is 10:01 AM.

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

About Us

"It's about Microsoft Excel"