Hello.

I've got a workbook in Excel 2003 that, for the most part, needs to be
read-only (if users save a copy of it, that's fine - I just don't want them
screwing up the "master" version).

However, there will be occasions when I don't want it to be
read-only...namely, if I have to add more data to the file. Once that's done,
I want it to be read-only again. Is there a way I can turn read-only on and
off while I've got the file open? That way, the window of when it's "exposed'
is as small as possible.

TIA.
--
Hmm...they have the Internet on COMPUTERS now!

See this site: http://www.softheap.com/ffp.html

"MDW" wrote:

Hello.

I've got a workbook in Excel 2003 that, for the most part, needs to be
read-only (if users save a copy of it, that's fine - I just don't want them
screwing up the "master" version).

However, there will be occasions when I don't want it to be
read-only...namely, if I have to add more data to the file. Once that's done,
I want it to be read-only again. Is there a way I can turn read-only on and
off while I've got the file open? That way, the window of when it's "exposed'
is as small as possible.

TIA.
--
Hmm...they have the Internet on COMPUTERS now!

Thanks for the link, but this effort has a budget of $0.

:)
--
Hmm...they have the Internet on COMPUTERS now!


"JLGWhiz" wrote:

See this site: http://www.softheap.com/ffp.html

"MDW" wrote:

Hello.

I've got a workbook in Excel 2003 that, for the most part, needs to be
read-only (if users save a copy of it, that's fine - I just don't want them
screwing up the "master" version).

However, there will be occasions when I don't want it to be
read-only...namely, if I have to add more data to the file. Once that's done,
I want it to be read-only again. Is there a way I can turn read-only on and
off while I've got the file open? That way, the window of when it's "exposed'
is as small as possible.

TIA.
--
Hmm...they have the Internet on COMPUTERS now!

I use the following to send a master copy of a timesheet file from
"MyDocuments" out to one of our shared directories.

Sub Send_Copy()
Dim mypath As String
Application.DisplayAlerts = False
mypath = "\\S:\shared\Dir1\Dir2\" & _
ThisWorkbook.Name
SetAttr mypath, vbReadOnly = False
Kill mypath
ActiveWorkbook.SaveCopyAs mypath
SetAttr mypath, vbReadOnly
Application.DisplayAlerts = True
End Sub


MDW wrote:
Thanks for the link, but this effort has a budget of $0.

:)
--
Hmm...they have the Internet on COMPUTERS now!


"JLGWhiz" wrote:

See this site: http://www.softheap.com/ffp.html

"MDW" wrote:

Hello.

I've got a workbook in Excel 2003 that, for the most part, needs to be
read-only (if users save a copy of it, that's fine - I just don't want them
screwing up the "master" version).

However, there will be occasions when I don't want it to be
read-only...namely, if I have to add more data to the file. Once that's done,
I want it to be read-only again. Is there a way I can turn read-only on and
off while I've got the file open? That way, the window of when it's "exposed'
is as small as possible.

TIA.
--
Hmm...they have the Internet on COMPUTERS now!

When I wanted to do this, I'd use windows explorer to mark the file readonly.

But I'd keep a copy of the workbook elsewhere--actually two copies. One was my
backup and one was my "in-work" version.

I'd do all my work in the test version and get it working. Then I'd use windows
explorer to copy the file to its real home (deleting the old version and marking
the new version as readonly).

(and copy it to its backup location, too.)

Marking the file readonly only makes it a little more difficult to screw it
up--not impossible.

MDW wrote:

Hello.

I've got a workbook in Excel 2003 that, for the most part, needs to be
read-only (if users save a copy of it, that's fine - I just don't want them
screwing up the "master" version).

However, there will be occasions when I don't want it to be
read-only...namely, if I have to add more data to the file. Once that's done,
I want it to be read-only again. Is there a way I can turn read-only on and
off while I've got the file open? That way, the window of when it's "exposed'
is as small as possible.

TIA.
--
Hmm...they have the Internet on COMPUTERS now!

--

Dave Peterson

If you do not think users will purposely try to break a password try this.

Open a file that is not read-only. In the Save As dialog there is a Tools
button. Click on it to see "General Options". Put a password in the
"Password to Modify" box. Close the file. On reopening there will be a
choice of entering the password or clicking on a read-only button.

The other suggestions for making a copy available to users may still be more
to your liking. Passwords have a way of being forgotten.

MDW wrote:
Hello.

I've got a workbook in Excel 2003 that, for the most part, needs to be
read-only (if users save a copy of it, that's fine - I just don't want them
screwing up the "master" version).

However, there will be occasions when I don't want it to be
read-only...namely, if I have to add more data to the file. Once that's done,
I want it to be read-only again. Is there a way I can turn read-only on and
off while I've got the file open? That way, the window of when it's "exposed'
is as small as possible.

TIA.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200609/1