read only

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...

I have an Excel Sheet that we use to track project progress. This sheet is open almost around the clock as people are constantly entering information into this sheet. I then have a PowerPoint presentation which links to this Excel file and grabs some graphs from it and then displays this...

Hi, Does anyone know how to force OpenDatabase to open as read only. I've tried setting the ReadOnly argument to true to no avail. The main curveball is that the security on the file only allows users "Read & Execute" priviledges, but even trying to use the ReadOnly argument results in an...

Help! Hopefully this is an easy one. I have an xlsm file. I can open in excel 2003 with no problems. When I open in excel 2007 it is read only. I have checked what I would call "the basics". Any ideas?

If I code the book to hide sheet1 when I close the sheet, I want the code not to show sheet1 when the workbook is opened in read only mode but show sheet1 only when users enter the book by entering the password. Not sure if this is possible Thanks for helping!;)

We have approx 200 employees who use Excel 2003 and have each registered under the following within Excel: Tools - Options - General tab - User Name However when selecting a file, others and myself have received a notification that "Joe Bloggs" has the file open. After contacting him, he...

Hi I'm using code so that when a workbook is read only, it treats it as saved, so the Save prompt doesn't come up. This is in in BeforeClose event. However, if a user opens the spreadsheet (as read only) and does work in it, without bearing in mind it's only read only, then it would not come...

hello people. I am confused. I have written a macro which asks various questions of users in message boxes, then copies the results sheet to a new workbook, which is saved with a new name. So far so good. However, having saved the results, I wish to close the original questionnaire file...

Hi all. First post so please be kind. After searching this site and it seems, the entire of google, I have accepted defeat and I come to you cap in hand. I have an excel workbook (2003) that around 5/6 people have access to. I wanted some version control auto saving and found a macro to do what...