Questions

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

1 answer

VBA to Add / Delete Watermark on Each Page

I am programming a form that will allow us to print out the current document while (1) adding a Watermark (which must appear on EVERY page) and then (2) removing that watermark. My code now only puts the watermark on the first page. Also, is there a way…

asked

Anonymous

edited an answer

Anonymous

1 answer

Microsoft Graph SDK - Calendar of user is always null

Our application is registered in Azure and has application rights for Users.Read.All (Admin consent - yes) and also Calendars.ReadWrite. By using the Graph SDK - ConfClientAppBuilder (ClientId, ClientSecret) we can access the users, but almost all…

asked

Martin Dill 6

edited an answer

Martin Dill 6

3 answers

How can I create a drop down menu that is a list of different color options (not color word descriptions)?

I want to insert a drop down menu within a table, so that the list of items to choos from is actually a list of pre-determined colors (actual colors) not the words of colors. I know how to create a drop down menu where the list is for…

asked

Anonymous

edited an answer

Anonymous

1 answer

MS Outage on 12-11-26

Hi MS Support, Any update on the the system outage on 12-11-26? Appreciate your feedback. regards Jayden

asked

Kapi, Jayden 0

edited an answer

Kai-Ex 2,655 Microsoft External Staff Moderator

1 answer

Will a Normal Paste Macro Paste Into a Protected or Hidden Area or Sheet?

Just would like to know before I get into a macro for a button that will execute a number of functions, including Copy/Paste. I guess I am asking 2 questions really: Paste into a cell protected area? Hidden sheet or cell range? Thanks

asked

Anonymous

edited an answer

Anonymous

1 answer

entourage 2008 mail could not be received at this time error message

I have been using Entourage 2008 since upgrading to Office 2011 a year ago because I did not want to spend $100 to move to Outlook. Entourage 08 worked great until about 6 weeks ago then the error message above started popping up regularly. I have a…

asked

Anonymous

edited an answer

Anonymous

5 answers

Hyperlink Text in a Excel Row Automatically

I have one excel sheet called product.xls and an Excel template with product detail fields. I open this excel sheet. Whatever I type in the first column, should get converted to a hyperlink. So let's say I typed 'Roger' in A6. Roger should be…

asked

Anonymous

edited an answer

Anonymous

2 answers

Get-MgSitePermission is returning a $Null value

Hi, I have the following. PowerShell: 7 Graph Module: 1.11.0 Sharepoint Site: ITTeam Graph Authentication: Application Authentiation with the following scope Sites.Selected Sites.Read.All Sites.Manage.All User.Read.All…

asked

Faris Malaeb 26

edited an answer

Faris Malaeb 26

15 answers

Generate set of Passwords in Access

I ha ve an access database that contains the following columns : UserID |First name | Last Name | Username I would like to add a password column as well and generate random passwords for the number of records found in my database , example if I have 50…

asked

Anonymous

edited an answer

Anonymous

1 answer

Azure Data Factory Linked Service settings for SQL is not consistent when deployed via CI/CD

In the development Azure Data Factory (ADF) the linked sql connection's Authentication Type is set as System Assigned Managed Identity. As shown in the image bellow. The ADF is connected to Azure Repo and when deployed via ARM template in CI/CD…

asked

Desmond Fernando 31

edited an answer

Desmond Fernando 31

7 answers

Is it possible to lock a formula on a template without protecting the sheet?

I'm trying to lock the formula cells so that they can't be tampered with, but if I protect the sheet it prevents rows from being copied and pasted (even with the "insert rows" option ticked) without unprotecting the sheet, and when the sheet is…

asked

Anonymous

edited an answer

Anonymous

1 answer

How to password protect a folder in Microsoft Office 2003

I need to password protect an entire "FOLDER in Microsoft Office 2003. I am also on a network, using a Buffallo drive, back up system, trash flies adn want to make sure all content filex in this folder as password protected etc. I am using Windows…

asked

Anonymous

edited an answer

Anonymous

11 answers

How do I bold a word or date in a formula

Hi, I need to bold a word in a paragraph in excel. There is a reference to the cell in the paragraph but it is not formatting the information the same as the cell when it goes into the paragraph. Examples below. This Order Form is valid only for…

asked

Anonymous

edited an answer

Anonymous

39 answers

insert row in protected sheet by keeping formula

Hi I have a protected sheet contain formula in each row depends to above row( for example C2=C1+1; C3=C2+1;...).and cells contained these formula are locked. I like to allow users to insert row everywhere by keeping formula without unprotecting the…

asked

Anonymous

edited an answer

Anonymous

1 answer

Macro to save as read only

Can anyone help me with a macro that will save a worksheet as a read only with a password to open (editable)? Thanks

asked

Anonymous

edited an answer

Anonymous

0 answers

Office Add In Single Sign on - Access token Expiry

I have a word addin which uses Office.auth.getAccessToken for authenticating with azure. Does this access token has an expiry defined ? I could not see any expiry key on the response from getAccessToken().

asked

Dhiluraj V 46

0 answers

Macro - Query MySQL Database with DSN-less Connection

Can anyone help me with writing a macro to query a MySQL database? From Excel? I can successfully query the remote MySQL db using MS Query and a DSN. But I need to make it more portable, so multiple users can grab the file and work on it anywhere. I…

asked

Anonymous

1 answer

VBA, ODBC Authentication, and Passthroughs

My company is in the process of meeting certain guidelines to make steps toward going public. One of those steps involves analysts to have to change their ODBC passwords every 30 days. Not awful for adhoc type deals, but I have a reporting box that…

asked

Anonymous

edited an answer

Anonymous

Filter

Answers

Comments

1,887,306 questions

Multivariate correlation?

VBA Public Constant named "Password" loads as stars

VBA to Add / Delete Watermark on Each Page

Microsoft Graph SDK - Calendar of user is always null

How can I create a drop down menu that is a list of different color options (not color word descriptions)?

MS Outage on 12-11-26

Will a Normal Paste Macro Paste Into a Protected or Hidden Area or Sheet?

entourage 2008 mail could not be received at this time error message

Hyperlink Text in a Excel Row Automatically

Get-MgSitePermission is returning a $Null value

Generate set of Passwords in Access

Azure Data Factory Linked Service settings for SQL is not consistent when deployed via CI/CD

Is it possible to lock a formula on a template without protecting the sheet?

How to password protect a folder in Microsoft Office 2003

How do I bold a word or date in a formula

insert row in protected sheet by keeping formula

Macro to save as read only

Office Add In Single Sign on - Access token Expiry

Macro - Query MySQL Database with DSN-less Connection

VBA, ODBC Authentication, and Passthroughs