Questions

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

5 answers

How to suppress SQL Server Login prompt if append/connection fails?

I have been figuring out how to link my SQL Server back end tables to my Access front end using VBA (not via DSN). I think I worked all of that out in the following…

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

0 answers

Deleting CommandButton after running macro

I'm trying to delete the CommandButton that runs my macro. The rest of the code simply locks every sheet after the first sheet. Here's my code: Private Sub CommandButton1_Click() For i = 2 To Sheets.Count Sheets(i).Activate …

asked

Anonymous

1 answer

Streamlining VBA to hide/unhide rows

Hi, I have 4 worksheet change events and the idea for each is that, if the value in column BX for a row within the applicable range is "Hide", then that row should be hidden (otherwise unhidden). The below code works, but is slow/inefficient…

asked

Anonymous

edited an answer

Anonymous

1 answer

Excel remove password multiple files on network

I need to remove the workbook open password (which is the same) to multiple files on our network. I found a code dated back in 2014 by Graham Mayor; however, I am unable to hide or set automatic update all links. I tried many UpdateLink= or := options …

asked

Anonymous

edited an answer

Anonymous

2 answers

Excel Password Protection with VBA and Manual UnProtect, or vice-versa

I am a relative beginner in using VBA. So, my apologies if this should be inherently obvious. I have a workbook of 9 spreadsheets that i am trying to keep protected. While executing my VBA code i will unprotect a sheet using **sheetx.unprotect password…

asked

Anonymous

edited an answer

Anonymous

1 answer

Only run one time when worksheet open

Hi I would like to ask that that I have a code on worksheet open() which I would like to run one time only means once the file is open first time it will execute the code after closing the file and then the same file will open then it wont execute the…

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,005 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

2 answers

MS Word Macro - Save As with Date and Text Filed (Bookmark)

Hi, New to using Macro's however; I am looking to create a command Button to activate a Macro which saves the document in a specific location (i.e. company server - shared folder). Also i want it to create a new file name using a Text field in the…

asked

Anonymous

edited an answer

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,830 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

Filter

Answers

Comments

1,627,389 questions

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

How to suppress SQL Server Login prompt if append/connection fails?

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

Deactivate Office 2013

Deleting CommandButton after running macro

Streamlining VBA to hide/unhide rows

Excel remove password multiple files on network

Excel Password Protection with VBA and Manual UnProtect, or vice-versa

Only run one time when worksheet open

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

MS Word Macro - Save As with Date and Text Filed (Bookmark)

Outlook outage

Set Protect Sheet Edit Object parameter using VBA