permission

  1. B

    No Read Permission message

    Anyone know how to clear this issue. I get this message with any query I run associated with this table and can't find this table anywhere now. I no longer see tt in my relationship either. I tried deleting my import table and rebuild it but, I can't do that either. RAW_NJUNS is the name of my...
  2. R

    Mac: Permission Denied (images within spreadsheet)

    I have my spreadsheet set up so on Sheet2 there are 2 columns of titles and the 3rd column is an empty cell. Next to this empty cell is a button that the user can click, a file browser opens up, and they can choose an image. Selecting an image will insert the file path into the cell and insert...
  3. T

    Permission denied - Run time error 70

    Hello, I'm trying to duplicate and save my active workbook but for some reasons, the following error is popping up during the macro execution; "Permission denied - Run time error 70". I tried to browse around but i still cannot find where I made the mistake in the coding. Any help would be...
  4. B

    Find Duplicates based on multiple criteria

    Hi There I work at a large hospital and we have an issue with our door access system in regards to cards having duplicate doors placed on cards and this is causing some not to work. I have attached a sample which shows the cards with their contents. I need to reference each cards contents to a...
  5. K

    Permission denied, sometimes, when writing an array to listbox...why?

    This line of code sometimes results in a "permission denied", but other times it works fine. UserForm5.ListBox1 = arrayOutput Seeking help/ideas/suggestions
  6. F

    Help with formula tabulate values

    Hello, May somebody help me how to tabulate with a formula the following information please. <tbody>#CACACA [/URL] "] A B #CACACA [/URL] , align: center"]1 STAGE 1 #CACACA [/URL] , align: center"]2 ID 0 #CACACA [/URL] , align: center"]3 NAME JFMSC #CACACA [/URL] , align: center"]4...
  7. V

    Save Theme Permission Denied

    Hello, Does anyone have any idea why this line of VBA: ThisWorkbook.Theme.ThemeColorScheme.Save ("C:\myThemeColorScheme.xml") works fine for me, the person that created the workbook, theme and macro but throws up a 'Permission Denied' error for anyone else?
  8. I

    Cross referencing two User permission tables and presenting as a single table

    I'm analysing some system role based permissions, to understand and display which users have access to which permissions and perform a comparison. The way the data has been presented to me so far is such that I have one table that presents permissions mapped into groups permission profiles...
  9. T

    The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to

    Hi All, I have several source xlsx. files saved on the drive (offline) and on the sharepoint. I am able to refresh the powerpivot via "existing connections" except for 1 file (see error message below). I have full control permission. The file is not in use by anyone else. I have re-loaded...
  10. R

    workbook changed to read only

    Hi everyone, so I have a workbook for my tenants when they pay their rent. I've created a template and have been using this method for a few years now. Today I try to make an entry and save it but when I clicked on File, two highlights came up. One said the workbook sheets are protected...
  11. O

    Read only mode if workbook is already opened

    Hello, Me and my colleagues have several workbooks in a shared environment (Druva in sync). We have some problems with conflict / duplicates files that are generated when more than one user open the same file and edit it. I'm aware that there are some vba solutions for this issue. However...
  12. S

    Using macro without permission?

    Hey everyone, I am a new user on Excel and I have been using tutorial succesfully so far, however im stuck with a problem. I needed drop box for a project so I used activex dropbox and needed the value of the drop box in a cell so i used range ("A1") = me.combobox1.value. Everything worked so...
  13. S

    Hidden VBA functions?

    I am looking in a VBA project I've downloaded and have found following code SQL = "BEGIN budget_p.upload_from_excel(" & ... & "); END;" I've looked through the entire project for the names "budget_p" and "upload_from_excel", but can't find anything. The project is helping me update and...
  14. S

    Modify Allow Edit Ranges in a shared workbook

    Hi, I've set up a sharing workbook but have a problem with permission. I want it to effectively 'lock' the input for users after they 'submit' their data. The specific user cells have been made accessible using Allow Edit Ranges in protected worksheets. Accordingly I'm wondering if there's...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top