readonly

Hello every one... I have a macro that checks the Excel Version/ Build in the 'workbook.open' statement. If the version/ build <> 16.14332, the file should open as 'Read only'. Currently I am just running a macro that is locking every single sheet/ cell to avoid changes being made (some...

Hello Everyone Been scouring these forums for a few days before deciding to make my own account... There's been many topics that come extremely close to what I'm looking for, yet none have been the exact same to my knowledge. So, I'd like for the entire workbook to be Password protected upon...

Is there a way to make this save the copy as read only? path = "\\hinas1\MFG\LED\SSL Paperwork\U502\U502FogLBFirstArticle" nom = Left(ActiveWorkbook.Name, (InStrRev(ActiveWorkbook.Name, ".", -1, vbTextCompare) - 1)) & " " & Year(Date) & "-" & Format(Month(Date), "00") & "-" &...

Hi frnd, Can we create read-only Linked table , so that user won't able to delete/update anything table. below code works, but it doesn't create readonly access. Any help would be appreciated. DoCmd.TransferDatabase TransferType:=acLink, _ DatabaseType:="Microsoft Access", _...

Dear all, I have a workbook that contains macros and this has been passed out to the user community by being saved in the XLSTART folder (as a hidden file) so when they open excel it is opened automatically in the background and they can use the macros within. This means that a number of users...

Hello, Question is in bold below! I've recently been pulled into a new team at work. There is a spreadsheet we all use and populate/update with various bits of data many times a day. One of my biggest frustrations (already!) is people overwriting changes I make to the spreadsheet because...

Dear everyone! I'm completely new to this site - so forgive me in advance.. I'm no genius - especially not when it comes to VBA, but I thought that you guys are, so: I have a macro in my excel worksheet that does following: Saves the active sheet as a PDF The code looks like...

I need to make a certain workbook be open in a seperate instance of Excel. I am aware that you can open a new instance of Excel and then open the file, unfortunately not all users of this file are aware of this. Private Sub Workbook_Open() If Application.Workbooks.Count > 1 Then...

I want to make a worksheet in my excel to have only read only access (user shouldn't be able to make changes to that sheet). I tried protecting the worksheet but making so will give an error in my code. My code basically makes some changes into that worksheet. Is there a way out to make the...

Hi all, I am new to excel and see how helpful everyone is here. This one has been plaguing me for weeks. I am creating a spreadsheet for work that has several links to word files. All of them are protected by admins and I have no access to making them not Read Only. Clicking the Read only...

Hi, I have placed an Add-in in a network drive and installed in each workstation all using Excel 2007 without copying it to the local Addin folder in order for everyone to access the same Addin as read-only except myself who is allowed to make changes and save. I have set-up the Workbook_Open...

I've just upgraded to Excel 2010 from 2003. An internal add-in that is heavily used uses the Application.GetSaveAsFilename method to prompt for file names to be used for an export process (exporting information from the current Excel file into an xml configuration file). In 2003, even if they...

I have a large complex workbook containing many ranges of product line items. The line items consist of both unprotected (i.e. PartNumber, Quantity) and protected (i.e. price x quantity formula) cells. Once the order is complete, I would like to offer the ability to save a completely Read...

Hi, i have an excel production planning tool on a network. I want certain users (3) to be able to open the workbook and edit the data, whilst I want everyone else to be able to open the workbook. I think this can be done using ChangeFileAccess but I am struggling. Any ideas on what I need...

Environment: Excel 2003, IE7.0 I am having unexpected vba script errors when opening a spreadsheet in a IE in readonly mode. The code works correctly in readonly mode if opened outside of IE. It also works correctly inside of IE if not in readonly mode. Dim ws as Worksheet Set ws =...