read only

I have a Spreadsheet that has Read Only Recommended. When a user wants to Save it, I want a new Filename entered by the user, and to make sure that the Read-Only Recommended status is switched off (i.e. Read-Write always On) Although my users can do this by File-SaveAs, most of them forget to...

Hey everyone, I've used this site a lot and am looking for a particular problem that I can't seem to find an answer to. I have a textbox that I have in my userform and am looking to autopopulate the first line with the current date (Have no trouble doing this). I am also looking to make that...

I have a macro that opens up a file of forms, makes customizations, and saves each worksheet in that file as it's own form in the new project. It works great (self pat on the back here), EXCEPT that I have users complain that they have to hit the Read-Only button. Obviously, having to wait the...

Hi all, I have an Access 2010 database that is on a shared drive so many people use it, and i want to password protect it so only those with a password can get into the actual file (in case we need to make updates to it.) I'm able to put password protection on the file, but the problem is that...

Hi Guys, This is quite hard to explain (Bit of a noob) so bear with me. Basically, I have 3 sheets looking at each other, one for 3 different departments in the company I work for one for Purchasing, one for Warehouse & one for our accounts, using the "pull data" function in separate tabs, I...

Hello, I'm trying to open, write-to, save, and close a workbook in VBA. I'm using the .close(true) method. I've also tried the following. Sub UPDT_DLY_PRDCT_CNT() Dim XLapp As New Excel.Application Dim ObjXL As Excel.Workbook Set ObjXL =...

Hi Is there a way of automatically opening the spreadsheet as Read-only depending on the user ID? Alternatively, if the spreadsheet is protected by default, is there a way of unprotecting it when opening, depending on the user ID? Thanks Jon

I have a workbook with 2 sheets in Excel 2010, and I'm trying to make the workbook read-only without editable fields. I have protected the workbook's structure under the review tab, made the document "marked as final" and went to the Save as\tools\general options\password to modify, and checked...

Excel 2003: Open Write Reserved Workbook (write reserved password) as Write Access without prompts Is it possible to open a read only recommended file with code (in another workbook) in such a manner that it does not ask for a password (i.e. the code must supply the password) and changes can...

Hi All, I currently have the following macro which makes all files in a particular folder read only: Sub setFileReadOnly() Dim sPath As String Dim sFile As String sPath = "C:\Users\tp\Documents\B\*.*" sFolder = Dir(sPath & "*.*") Do Until sFile = "" SetAttr...

I have two workbooks; one is read only and displays information for several users to view at once, and the other is an 'update' sheet that users enter information into which is transferred to the read only file (by saving over the file). Is there a way of notifying a user viewing the read only...

Hi all We have a shared workbook here that several people have access to. Sometimes the sharing is switched off temporarily due to restrictions in functionality that occur when you share a workbook. At the moment, unfortunately, sharing is switched off. I say unfortunately because at the...

I have a small office with 4 computers including 1 server. All documents need to be accessible by all workers on all computers. My problem is that every time a document is created on one computer, even if it's first save is to the server, no one else has read write privileges on it until we...

I have a shared workbook on a shared drive. About once a week it says its locked by another user and that I can only open as read only. The only problem is the user name it gives either has excel closed or has their entire computer turned off. I cant seem to figure out why.

Hi All, I have an application on MsAccess2003, generate all sort of reports on Excel I've got one of the code to change the excel file to read only using the following code its working file Case "XLS" bEvent = CreateXLSReport(RunningTask) If...

Hello - I am looking for assistance with my Auto_Open macro. Currently it forces the workbook closed after a designated expiration date. I'm trying to alter it so that users have read-only access to the workbook after it expires, rather than forcing it closed. Any suggestions would be greatly...

Some users still have 2003 loaded and don't want to upgrade. I tried having them open the .xlsx file, it converts fine, but opens as read only to "protect the original document". They can't save anything. Is there any fix short of giving them only .xls files ? Mike

I have Microsoft Excel for Mac 2011, Version 14.1.2 on my computer. The only reason I ever use Excel is to manage our family budget. I don't share this document with anyone/am not linked to any public network or server of any kind, and have never set permissions on the document. But, every...

I have an Excel document saved in a shared folder on our server. I usually always have this document open and everyone else can open it as read only to view the information they need. This document will not open on one persons computer while I have it open on my computer. The prompt to open...

Hi All, I have an excel spreadsheet that is linked into an access database through ADO connections. The spreadsheet is set up to make updates and adds directly into a table in my database. The database is on a server, what is happening is, and I don't know the cause, the database is being put...