Questions

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

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 26

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

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

14 answers

Insert row in a table on protected worksheet

Excel 2007 tables have this feature to add row by pressing the keyboard tab on last cell of last row. But if the workbook is protected the error message is displayed saying "cannot use this table feature with protected worksheets". I want to…

asked

Anonymous

edited an answer

Anonymous

0 answers

COnverting multiple pages in a single Word document to individual pages

I have a Word document that contains 12 seperate job descriptions, each is a seperate page within the document. Is there a quick way to save each page as it's own document??

asked

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

Filter

Answers

Comments

1,887,725 questions

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

You cannot use this command on a protected sheet.

Can I allow macros to run on a protected sheet?

Insert row in a table on protected worksheet

COnverting multiple pages in a single Word document to individual pages

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.