Read only issue

[ukphoenix]

I have a problem with a created workbook I have.
On opening I get a pop-up asking

'Workbook.xls' should be opened as Read-Only unless you need to save changes to it. Open as Read-Only ?
with the options yes , no , cancel

How can I prevent this pop-up from appearing

[VBA Noob]

File > Save as > tools dropdown > select general options > untick read only

http://www.bettersolutions.com/excel...E618512332.htm

VBA Noob

[ukphoenix]

I have no Read only option at this address.
I am using Excel 2000

[VBA Noob]

Right click excel file > properties > in general tab untick read only

VBA Noob

[ukphoenix]

looked at this and Read Only IS unchecked

[VBA Noob]

Maybe be a verison issue

See if link helps

http://support.microsoft.com/kb/211483

VBA Noob

[ukphoenix]

tried that link it gives exactly the same solution

Turn Off the Read-Only Prompt and Save File in the Excel 97-2000 & 5.0/95 File Format
1. Open the file in Microsoft Excel 2000.
2. When you are prompted to open the file as read-only, click No.
3. On the File menu, click Save As and, in the Save as type list, click Microsoft Excel 97-2000 & 5.0/95 Workbook.
4. In the Save As dialog box, on the Tools menu, click General Options.
5. Click to clear the Read-only recommended check box, click OK, and then click Save.

The problem I have is I do not have a general options tab in the dropdown menu.
The options I have are Delete, Rename, Print, Properties (all of which are shaded) and only Add to Favourites, Map Network Drive selectable

[VBA Noob]

You should have the option

http://www.microsoft.com/technet/pro...ps/exsave.mspx

maybe upload the file and we can untick for you

VBA Noob

[ukphoenix]

Id rather not make the file for public access....would it be possible to mail it to you

[VBA Noob]

I will PM you my e-mail address

VBA Noob

[ukphoenix]

Thanx VBA workbook sorted.......any ideas what has happened as to why I do not have a general optins tab

[VBA Noob]

Glad you got it sorted.

Not sure why you wouldn't have the general options tab

Do a google search to see if someone else has had the same problem

VBA Noob

[VBA Noob]

ukphoenix,

Are you sure you clicked file > save as and not file open just below.

Both dialog boxes look the same but the file > save as has the general options tab

VBA Noob