Questions

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

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 11

edited an answer

Desmond Fernando 11

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

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

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

4 answers

You cannot use this command on a protected sheet.

I have created a worksheet in which I've group certain rows. When I protect the sheet, the group function is no longer useable, I get the following error message: "You cannot use this command on a protected sheet. To use this command, you must first…

asked

Anonymous

edited an answer

Anonymous

3 answers

Can I allow macros to run on a protected sheet?

Maybe the answer is a simple no, but I figured I'd ask. I just want to run a simple macro that performs a filter function so I can hide the filter arrows and simplify the filtering. When I try to run the macro while the sheet is protected, I get the…

asked

Anonymous

edited an answer

Anonymous

2 answers

Downloadable Send to OneNote 2007 Print Driver for 64-bit System?

I purchased MS OFfice Home and Student 2007 in 2007 specifically because it had OneNote (which I use to send program files as well as Internet pages to in order to save, organize and print). Recently my HP Vista laptop died the blue-screen-of-death. …

asked

Anonymous

edited an answer

Anonymous

2 answers

Images, compression, & file size

Hi Folks, I have an Excel file I am working on with an image box that has click event code to insert a picture. I've been trying to include code to automatically compress the image. The file size gets huge. The file size is 48 kb, if I insert a 5.0 MB…

asked

Anonymous

edited an answer

Anonymous

3 answers

How to allow 'Group/Ungroup' on a Protected and Locked Worksheet

Right, this may be structures and security so lets try... I have a pretty big Excel Progress Claim workbook, that is 'organised' with worksheets (tabs) like below: Actual Claim summary, working over 968 lines for the Project work items Several tabs…

asked

Anonymous

edited an answer

Anonymous

24 answers

Expanding/Collapsing Grouped Columns/Rows When a Sheet is Protected

I want to protect the locked cells in any given spreadsheet so that the user cannot override formula cells. I have also grouped columns that contain historical information. When I protect the sheet, I cannot expand or collapse the grouped columns. I…

asked

Anonymous

edited an answer

Anonymous

1 answer

ODBC Database sources across multiple personel and Access database queries.

Currently running linked ODBC database source tables into multiple Access queries. These tables are imported as a linked table to the source and granted permissions to them through one main password into the server. Effective February 2010, a new…

asked

Anonymous

edited an answer

Anonymous

2 answers

Outlook email hasn't worked since this morning

How long is MS outlook (email) going to be out?? When do you estimate it will be back online?

asked

Patricia ware 0

answered

Lester Bernard Reyes 86,755 Independent Advisor

4 answers

Excel 2007 will not let me find and replace data in a protected worksheet. I have ensured that the cell ranges I am trying to change are unlocked.

Programme: Excel 2007 Error message: you cannot use this command on a protected worksheet..........

asked

Anonymous

edited an answer

Anonymous

Filter

Answers

Comments

1,315,854 questions

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

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

Macro to save as read only

VBA, ODBC Authentication, and Passthroughs

You cannot use this command on a protected sheet.

Can I allow macros to run on a protected sheet?

Downloadable Send to OneNote 2007 Print Driver for 64-bit System?

Images, compression, & file size

How to allow 'Group/Ungroup' on a Protected and Locked Worksheet

Expanding/Collapsing Grouped Columns/Rows When a Sheet is Protected

ODBC Database sources across multiple personel and Access database queries.

Outlook email hasn't worked since this morning

Excel 2007 will not let me find and replace data in a protected worksheet. I have ensured that the cell ranges I am trying to change are unlocked.