Questions

2 answers

Protect locked cells in multiple sheets

I would like to protect locked cells in MULTIPLE sheets in one workbook but it would take much to long to do each one individually. How do I do it across all sheets in one go?

asked

Anonymous

edited an answer

Anonymous

2 answers

Use VBA to query SQL Azure Database

I'm a PC Excel developer. I use ADODB a lot. I have a workbook that allows users to enter search terms and uses those terms to query a database on SQL Azure. It works perfectly. I need to make a version for Mac. YIKES! A whole new world. I've read and…

asked

Anonymous

edited an answer

Anonymous

1 answer

User delegated SAS token generated by Powershell command and Azure Portal different with SAS token created by Azure CLI

A User delegated(AD) SAS token created for storage account created by Azure portal or Powershell is different with a SAS token created by Azure CLI. Example: Azure CLI: az storage container generate-sas --account-name --name …

asked

Chetan Prakash Saraswat 11

edited an answer

Chetan Prakash Saraswat 11

0 answers

SSO URL redirects user to deprecated portal

Hello, When I use REST Api to get SSO URL to redirect user to our developer portal, the returned URL takes user to the deprecated portal: …

asked

SKate 116

7 answers

Autofill date when another cell is filled in (not blank) but need the cell to stay blank and not update when the file is opened.

Autofill date when another cell is filled in (not blank) but need the cell to stay blank and not update when the file is opened the next day. Using cells V1 and O1, in cell O1 I have =IF(A1<>"",TODAY(),"") but the date always…

asked

Anonymous

edited an answer

Anonymous

9 answers

Opening a Word Document

I've been using Word for 15 or so years! Since it first came out! And a new document always opened as Document1.doc. Of late a new document comes out as Template1? And all my settings are gone, as I like certain margin settings. It always reverts…

asked

Anonymous

edited an answer

Anonymous

1 answer

Retrieve SharePoint Online Root Site Collections list using CSOM lib or REST API without admin creds

Hi All, I'm trying to solve simple task : To retrieve root site collections list automatically. I know the easy way to do it using admin credentials and C# CSOM library, but it would be much better to use something like admin-consent (Graph API) flow to…

asked

Anonymous

edited an answer

Anonymous

1 answer

Deactivate Office 2013

I purchased Office 2103 during the summer of 2014. The machine I had installed the license is no longer available, and I have lost my username and password for the Microsoft account I had setup for activating Office 2013 originally. How do I deactivate …

asked

Anonymous

edited an answer

Anonymous

2 answers

microsoft, I can't Login to OneDrive

I am connected to internet, but it shows this error.

asked

Jarred Zhang 0

answered

Emma1-N 15,165 Microsoft External Staff Moderator

7 answers

How to automate the process of locking cells when they contain data

In Excel 2003, to protect data entered in cells, and allow only editing empty cells, I do the following: In an empty worksheet, I select all cells, and Format | cells | protection | uncheck locked property. After I enter data in some cells, I select…

asked

Anonymous

edited an answer

Anonymous

3 answers

Can you protect and unprotect all the sheets in a book at once

I have several books and I protect each sheet in the book. When I have to work on the sheets I unprotect them. Can I do this all at once or do I have to each sheet? If I protect the entire book does that do all the sheets and may be better way of…

asked

Anonymous

edited an answer

Anonymous

1 answer

Changing Form Field highlight and/or background color when document is protected

Can it be done? I am able to change the form field color programmatically, provided the document is not protected, but when not protected the document is much less useful as a form, because it is too easy for the user to accidentally delete the form…

asked

Anonymous

edited an answer

Anonymous

0 answers

Batch processing of password-protected Excel files

I have created a set of employee timesheets in a folder, each identified by the employees name and ID no, and protected by the employee's National Insurance No as a password. They will add their overtime and mileage claims to their spreadsheet and I…

asked

Anonymous

2 answers

Azure AD Connect password sync

Hello, we have installed office 365 and Azure AD Connect to migrate from on-premises DC. Noticed that the sync tool makes sync every 3 hours. I am wondering, if I want to block a user or change a password is there any way to trigger these changes so they…

asked

Anonymous

edited an answer

Anonymous

0 answers

Copying Drop Down Menus

Hi, I'm new here. I have a template that I use daily. It is formatted (bold/italic/sizes/bullets), and has both fill in text fields and drop down menus. Once I finish filling out the template, I copy the entire thing from Word and paste it into another…

asked

Anonymous

1 answer

Outlook outage

Okay, MSN...what's the update now? All day, nuthin.

asked

G. SCOTT SPENCE 0

answered

Lester Bernard Reyes 86,755 Independent Advisor

3 answers

Set Protect Sheet Edit Object parameter using VBA

I'm a novice to macros and previously found help on this site to write a macro that will allow grouped rows and columns to be expanded and collapsed on 2 protected worksheets in my workbook while retaining the protection parameters that I originally…

asked

Anonymous

edited an answer

Anonymous

5 answers

Color coding the check in a check box

Is there a way to color code the marking in a checkbox so that if someone marks certain checkboxes, they will stand out in color? For example, I have checkboxes for "Yes", "No", and "NA". If "No" is checked, I want…

asked

Anonymous

edited an answer

Anonymous

0 answers

Checkbox that enters username into cell to the right

Hello Everyone, I have a spreadsheet, and on some of the worksheets there are checkboxes in in the O column. When checked the VBA code I have should automatically put the persons username in the P column of the same row in which the box was checked. This…

asked

Anonymous

9 answers

Merged fields in Excel don't stretch to fit the text

Hi I have an excel 2010 spreadsheet that I use to Macro out certain sheets into its own file and within that sheet I have 3 columns but some of the rows are merged across those 3 columns. When I macro out the row does not auto fit the text because it is…

asked

Anonymous

edited an answer

Anonymous

Filter

Answers

Comments

1,625,161 questions

Protect locked cells in multiple sheets

Use VBA to query SQL Azure Database

User delegated SAS token generated by Powershell command and Azure Portal different with SAS token created by Azure CLI

SSO URL redirects user to deprecated portal

Autofill date when another cell is filled in (not blank) but need the cell to stay blank and not update when the file is opened.

Opening a Word Document

Retrieve SharePoint Online Root Site Collections list using CSOM lib or REST API without admin creds

Deactivate Office 2013

microsoft, I can't Login to OneDrive

How to automate the process of locking cells when they contain data

Can you protect and unprotect all the sheets in a book at once

Changing Form Field highlight and/or background color when document is protected

Batch processing of password-protected Excel files

Azure AD Connect password sync

Copying Drop Down Menus

Outlook outage

Set Protect Sheet Edit Object parameter using VBA

Color coding the check in a check box

Checkbox that enters username into cell to the right

Merged fields in Excel don't stretch to fit the text