Read Only, but not Read Only

[Guest]

In Excel 2000 we have a standard read-only worksheet which we save under
individual customer name using the "save as" function. When the customers
saved sheet is re-opened it opens as read-only when the file properties show
that read-only is not ticked.

How can we stop the file opening as read-only?

 

[Dave Peterson]

There are a few different ways that excel will open a workbook as readonly.

1. You can mark the file readonly in windows explorer.
2. You could be opening a workbook from a drive/folder that you have read
access--but not write access.
3. You could have a workbook that was saved with a password to modify.
Under: File|Saveas|tools

You said you didn't do the first option. I'd guess the second doesn't apply,
since you saved the customer file there originally.

And you should have seen a prompt in the third case (to specify a password to
modify). Did you and then choose to open it readonly?

And there's one more suggestion from Debra Dalgleish's site:

http://www.contextures.com/xlfaqApp.html#ReadOnly

Q. All of a sudden a number of my Excel 2000 files have become "read-only".

A. Clear out c:\windows\temp directory on the machine that houses the files,
then reboot.

If the file is on a network share, sometimes rebooting that server helps.

 

[Guest]

I had already checked Debra's solution before posting my original question (I
always search for similar questions before I ask one) but because this
particular worksheet sits in a folder on the server, along with about a dozen
other read only files that are treated the same way - ie "save as" under
customer name, and none of these have this problem, I guessed that this
wasn't the solution.

I think there's a macro which runs on file open that sets it to read only,
but I can't find the macro.

 

[Dave Peterson]

Try opening the workbook with macros disabled (toggle your security setting
temporarily).

You can also stop the auto_open and workbook_open events from running by holding
the shift key when you open your workbook.

After you open the workbook, hit alt-f11 to get to the VBE.
Look under the ThisWorkbook module for:
Private Sub Workbook_Open()

Look in all the General modules for
Sub Auto_open()

Debra Dalgleish has a web site (for a different purpose) that may help you
navigate your way through the VBE.

http://www.contextures.com/xlfaqMac.html#NoMacros

===
But it seems kind of odd that only this one workbook--based on a common
workbook--has this kind of macro.