read-only

So I have a spreadsheet on Google Drive that me and other people use for our employees. Every week we send out the spreadsheet to the employees for them to see. However, it does not help them because the spreadsheet is changing constantly. I need for them to be able to view the spreadsheet (or...

I have an issue with a couple of combo boxes - when the workbook is editable, they work perfectly as designed. However, when the workbook is in read-only mode, Excel asks the user if they wish to reopen the workbook every time a selection is made within the combo box. The workbook must remain...

Hi, I've been making some changes to a workbook for a few days and I have just found that something I've done has caused the input page to be protected in some way. It's a page made up primarily o drop-down lists, and when I try to change a cell I get a message "this cell or sheet is protected...

I've got an excel sheet from a guy at work who decided to lock the entire document down so I can't do anything with it. Virtually all the ribbon options are greyed out, there isn't anything locking it in the code, I've tried checking the save as "read-only" option and it's not there. Any ideas...

In prior versions of excel, you can protect a workbook and users when opening the file would be asked to enter the password to open with full editing priveleges or allow the user the option to open as read only. Apparently things have changed a bit in Excel 2010 and I cannot seem to replicate...

Hi all, I have the following code to open the file which has read-only option but my macro code will copy something from another file and paste in this file and save, so I need to choose a "No" to the read-only message when it tries to open the file. Currently, the message still pops up to me...

I set up this simple query, and then clicked the 'split form' button to turn it into a form. It works great, except that I can't edit current records, and can't add new records. I'm not sure why. I must be missing something obvious, but I'm relatively new to forms. Thanks for your help...

This is not a VBA question. We switched to 2007 just last Summer (I know, don't ask). We have noticed that for files created in Excel2007, when the file is opened, it creates a temp file in the same directory with today's date and the original file is still shown separately with the original...

Hi everybody, I am having an issue when opening (not downloading) my file from the website version of my company's email server, or from my company's actual corporate server itself. When I open the file, the private sub macros work. Any macros that are stored within the workbook or modules...

All, Firstly, thank you for any help you can provide. I have a workbook test.xlsm, which has two sheets, Data and Report. Then, I have some VBA that creates an ADO Connection to Data in order to run SQL to pull some data from Data into Report, see below. When I open the workbook it runs just...

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

Hello Saviours, Every time I protect a sheet, I can no longer sort any values in my tables. I check the box saying that users should be able to sort. But no luck. Even if I say we can do EVERYTHING to the sheet (and it's still protected) - it still says I cannot sort while the sheet is...

Hello All, I couldn't find an existing thread. Does anyone know if there is a way to either password protect or disable a macro (in this case a toggle button) if the spreadsheet is opened as read-only? I have the spreadsheet automatically open as read-only to users who do not have the password...