PC Review


Reply
Thread Tools Rate Thread

Cannot save macro spreadsheet due to ReadOnly = True

 
 
JingleRock
Guest
Posts: n/a
 
      27th Jul 2011
First, I checked the file Attributes in Windows Explorer, and left-
clicked on Properties: all three (Read-only; Hidden; Archive) were
blank.

I then ran the following:

Sub OpenGroup1()
Application.EnableEvents = False

Application.Workbooks.Open Filename:= _
"\\HOUDATA01\Investments\Research\Shared\RATINGS MACROS\MASTER
\Group 1 (M-Mkt) Master Macro.xlS"
'''''''''''''"\\HOUDATA01\Investments\Research\Shared\RATINGS MACROS
\MASTER\Group 1 (M-Mkt) Master Macro.xlS", UpdateLinks:=True,
ReadOnly:=False <<<< THIS DID NOT WORK!!

If (GetAttr(ThisWorkbook.Path & "\" & ThisWorkbook.Name) And Not
vbReadOnly) Then
MsgBox "The Workbook is Not Read-Only!!", vbInformation
End If

''''''''''ThisWorkbook.ReadOnly = False <<<< THIS DID NOT WORK!!

Application.EnableEvents = True
End Sub

The MsgBox pops-up, even though "[Read-Only]" is appended to the name
of the file at the top of the opening worksheet.

Help. I cannot save edits to the workbook.
 
Reply With Quote
 
 
 
 
Clif McIrvin
Guest
Posts: n/a
 
      27th Jul 2011
"JingleRock" <(E-Mail Removed)> wrote in message
news:0a24b2de-a22e-4f7b-bf01-(E-Mail Removed)...
> First, I checked the file Attributes in Windows Explorer, and left-
> clicked on Properties: all three (Read-only; Hidden; Archive) were
> blank.
>
> I then ran the following:
>
> Sub OpenGroup1()
> Application.EnableEvents = False
>
> Application.Workbooks.Open Filename:= _
> "\\HOUDATA01\Investments\Research\Shared\RATINGS MACROS\MASTER
> \Group 1 (M-Mkt) Master Macro.xlS"
> '''''''''''''"\\HOUDATA01\Investments\Research\Shared\RATINGS MACROS
> \MASTER\Group 1 (M-Mkt) Master Macro.xlS", UpdateLinks:=True,
> ReadOnly:=False <<<< THIS DID NOT WORK!!
>
> If (GetAttr(ThisWorkbook.Path & "\" & ThisWorkbook.Name) And Not
> vbReadOnly) Then
> MsgBox "The Workbook is Not Read-Only!!", vbInformation
> End If
>
> ''''''''''ThisWorkbook.ReadOnly = False <<<< THIS DID NOT WORK!!
>
> Application.EnableEvents = True
> End Sub
>
> The MsgBox pops-up, even though "[Read-Only]" is appended to the name
> of the file at the top of the opening worksheet.
>
> Help. I cannot save edits to the workbook.



The unanswered question in my mind is why the workbook is being opened
read only.

Can you (manually) do a "Save As" ??

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I save a spreadsheet from a macro? Cortez Microsoft Excel Misc 2 5th Mar 2007 05:14 PM
Spreadsheet save using a macro =?Utf-8?B?a21kYWx5?= Microsoft Excel Programming 4 22nd Feb 2006 11:31 AM
Disable Save As dialog on ReadOnly spreadsheet Andy Microsoft Excel Programming 1 28th Jul 2004 07:42 PM
Running Macro when value in spreadsheet is true Jonas Microsoft Excel Programming 3 22nd Apr 2004 05:32 PM
RejectChanges does not work when DataGrid ReadOnly = True Dunster Microsoft ADO .NET 1 19th Jul 2003 02:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:34 PM.