Questions

2 answers

Locking Cells for editing automatically after cell is populated

Hello, I am looking for a way to lock cells for editing after the cells are populated - does anyone know of a way to do this, or could you point me in a direction? Thanks! Joe

asked

Anonymous

edited an answer

Anonymous

2 answers

Login/Password Security On A Acess Database

I have a Microsoft Access 2007 database in a network environment that is split into a front end and back end setup. I currently have a d/b password set for security as there are limited number of users, but I would like to change that to each user…

asked

Anonymous

edited an answer

Anonymous

5 answers

I got Microsoft Office Professional Plus 2013 from my university and need to re-download, but I can't.

Hey, As I said I got Office through my university through "onthehub." Recently my HDD died so I got a new SSD. Now I need Office again and I can't get it downloaded. When I try to enter my product key…

asked

Anonymous

edited an answer

Anonymous

2 answers

Microsoft Outlook

MS Outlook is not working since yesterday night. Seems to be global outage. When we are expecting MS Outlook to be back? was Microsoft 365 and Office | Access |

asked

Shah, Nisha (Associated) 0

edited the question

Duane Hookom 27,035 Volunteer Moderator

1 answer

Outlook Issue

when will Outlook be fixed? Please let us know there is lots of emails that need action requried.

asked

Accounts 0

edited an answer

Roebe Ta 1,840 Independent Advisor

8 answers

VBA to Loop Through Files

Hi. I have a series of identical workbooks in a folder in the following location: C:\Users\hughesel\Desktop\Test I want to create a macro which will open each of the files in turn and select all of the contents on the QPI sheet and paste special values…

asked

Anonymous

edited an answer

Anonymous

15 answers

Error 3343: Unrecognized database format 'C:\Temp\Northwind.accdb"

I am tasked with connecting to an Access DB from a Word 2010 Macro. I downloaded the Microsoft sample database and the sample verification code but that does not work either. I can open the Access database so it does not appear to be corrupted. Using…

asked

Anonymous

edited an answer

Anonymous

1 answer

VBA Code to Password protect temp excel files - autoemail

Hello Using code from Ron de Bruin I have managed to get a list of data to split into separate files and then email to different recipients baaed on the vlue in colun A. The final thing i need to do is to password protect each file before i send it. Is…

asked

Anonymous

edited an answer

Anonymous

6 answers

Office 2010 or Office 2013?

Just got a new laptop with Windows 8. I need to get a new version of Office but don't know whether to get Standard 2010 or Standard 2013. I know that there's cloud storage with 2013 which I don't really need. Which version would be best or does it…

asked

Anonymous

edited an answer

Anonymous

3 answers

Office Professional Plus 2013

I just bought a new computer with a Microsoft office 2010 on it to install or activate. But I have Office Professional Plus 2013 and it won't recognize the product key which is correct and I don't have a disk drive on new computer to download it. So…

asked

Anonymous

edited an answer

Anonymous

0 answers

Get latest delta token for a mail folder

Why do you not support $deltaToken=latest for mail folder delta API? I need to pull changes to the mail folder from the current time. I am not interested in historical emails. Please let me know if that is possible or will be possible soon.

asked

Pradeep Makone 1

4 answers

Refreshing data on a protected worksheet

I have a workbook which is linked to several data sources. I want to be ableto protect one or more sheets so that all end users view the sheet the same (e.g stop colums widening etc). But when I do it fails to be able refresh data on that sheet? ANy ways…

asked

Anonymous

edited an answer

Anonymous

9 answers

Errors when protected... how to fix?!?

Ok so I thought I was done with my workbook and I start to protect everything, for realistic testing. But now in protected mode everything is giving errors because it says cells needed are protected.. even though their unlocked. So I was wondering if…

asked

Anonymous

edited an answer

Anonymous

7 answers

How to allow Data Validation changes using VBA while Worksheet is protected

Hi All, I've set up a grouping of Option Buttons that have assigned macro's, these assign different PullDown lists to a specific Merged cell range in the worksheet. They work great when I have the worksheet UN-PROTECTED. When I PROTECT the…

asked

Anonymous

edited an answer

Anonymous

10 answers

How to bind variables from Excel sheet to an SQL query in Excel SQL connection with Oracle

HI, In an Excel sheet I did an Oracle SQL Connection and i need to do display the following results: Select * From test_table where rownum < ??? Where ??? is equal to a data present in cell D4 of sheet 1. How do i write my SQL statement inside the…

asked

Anonymous

edited an answer

Anonymous

8 answers

Insert row in a table on protected worksheet

In the same way we can add rows into the table by clicking into the last cell in the row above the total row and then press the Tab key. It would be really useful if it could works in a protected sheet,workbook. How can I do it? Macro? how can i write…

asked

Anonymous

edited an answer

Anonymous

5 answers

How can I password protect all word files in a folder?

How can I password protect all word files in a folder? I know there is a macro for it I just cant write it. I can't get my head rounf visual basic I am only an admin who has to lock hundreds of files a month with the same password. Please someone give …

asked

Anonymous

edited an answer

Anonymous

0 answers

Mass formula change

Hi all, I need to change several formulas in several protected sheets. There are the formulas that need to be changed. They are located at Algoma-Working!B25 to Algoma-Working!B30: =COUNTIFS(Algoma!F3:F299, ">="&TODAY()-7) …

asked

Anonymous

0 answers

Multivariate correlation?

Can anyone see what I am doing wrong or otherwise explain how to calculate the multivariate correlation or Rsq using Excel formulas, not the Data Analysis Regression tool? I confess that I don't know what I'm doing. I am not familiar with multivariate…

asked

Anonymous

2 answers

VBA Public Constant named "Password" loads as stars

I have a vba module that contains a public constant called "Password" . I have been using the constant without any problems in my modules, but when I started using it in the workbook open event, it loads as "********" instead of its…

asked

Anonymous

edited an answer

Anonymous

Filter

Answers

Comments

1,624,767 questions

Locking Cells for editing automatically after cell is populated

Login/Password Security On A Acess Database

I got Microsoft Office Professional Plus 2013 from my university and need to re-download, but I can't.

Microsoft Outlook

Outlook Issue

VBA to Loop Through Files

Error 3343: Unrecognized database format 'C:\Temp\Northwind.accdb"

VBA Code to Password protect temp excel files - autoemail

Office 2010 or Office 2013?

Office Professional Plus 2013

Get latest delta token for a mail folder

Refreshing data on a protected worksheet

Errors when protected... how to fix?!?

How to allow Data Validation changes using VBA while Worksheet is protected

How to bind variables from Excel sheet to an SQL query in Excel SQL connection with Oracle

Insert row in a table on protected worksheet

How can I password protect all word files in a folder?

Mass formula change

Multivariate correlation?

VBA Public Constant named "Password" loads as stars