Questions

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

1 answer

I deleted my Gmail from Outlook 2021 because of Password change and now it will not reinstall

I realize now that there was a better way to change the password but chose to remove and reinstall. That was a mistake. When I try to manually add the account I am not asked for my new password. Gmail is off account settings but there is Gmail in Outlook…

asked

Anonymous

edited an answer

Anonymous

3 answers

ms file is not opening

we are not able to open our MS word file it is showing repair option

asked

Rashu Verma 0

commented

Teddie Dang 2,245 Independent Advisor

2 answers

How to make outlook require password for log in everytime?

i need outlook to require a password to log into my email,how do i make it do this? atm it auto log ins even after removing the account and adding it back or uninstall and reinstall.

asked

Anonymous

edited an answer

Anonymous

1 answer

My Outlook no longer syncs with Gmail.

I just got a new laptop and I cannot get my Gmail messages in Outlook. I have looked at the suggestions on this site and nothing worked. I keep getting an error message and can get no further. When I follow the instructions to update Outlook keeps…

asked

Anonymous

edited an answer

Anonymous

Filter

Answers

Comments

1,315,861 questions

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.

I deleted my Gmail from Outlook 2021 because of Password change and now it will not reinstall

ms file is not opening

How to make outlook require password for log in everytime?

My Outlook no longer syncs with Gmail.