Tag Archives: microsoft
Microsoft Teams DLP Playbook
May 2024 Edition
We’re so excited to publish the updated Teams DLP Playbook!
This document provides an overview of how enterprise customers can deploy Microsoft Teams-DLP for protecting sensitive information. Microsoft Purview Data Loss Prevention has integrations with multiple workloads that help to protect customer data with a single policy. Teams DLP is one of the workloads within Microsoft Purview Data Loss Prevention. This guide walks through the different aspects of deploying use cases across content/containers.
In summary, this playbook will help to:
Understand the new Microsoft Purview Portal console and interface
Develop a strategy for deploying Teams DLP across the organization
Provide near real-time Alerts with notifications
Review various scenarios to test Teams DLP over chat and channel communication
This document helps readers plan and protect sensitive information scenarios that normally exist in every organization. This playbook helps as a user guide to mitigate the risk of exchanging crucial data while communicating over chat or giving access to sites for guest users.
If you have any questions on this playbook or suggestions, please reach out to our yammer group at aka.ms/askmipteam!
Let us know what you think!
Microsoft Tech Community – Latest Blogs –Read More
Always use the same cell value in a formula
How can you keep the value of a cell same in all rows while the values of the other cells in the formula change per row
How can you keep the value of a cell same in all rows while the values of the other cells in the formula change per row Read More
Where can I find the DOM element for the microsoft search enterprise web connector?
I’m trying to setup the microsoft search enterprise web connector as described here: Enterprise websites Microsoft Graph connector | Microsoft Learn. The problem I’m having is with Dynamic Site configuration. I’m not familiar with DOM so I don’t know where to look to find the DOM Ready, Headers to Add, or Headers to Skip items. I assume it’s something I can find the the DevTools menu of the browser if I go to the site in question, but I don’t know what to look for once I’m there. Anyone who has experience with this, I’d appreciate your expertise.
I’m trying to setup the microsoft search enterprise web connector as described here: Enterprise websites Microsoft Graph connector | Microsoft Learn. The problem I’m having is with Dynamic Site configuration. I’m not familiar with DOM so I don’t know where to look to find the DOM Ready, Headers to Add, or Headers to Skip items. I assume it’s something I can find the the DevTools menu of the browser if I go to the site in question, but I don’t know what to look for once I’m there. Anyone who has experience with this, I’d appreciate your expertise. Read More
referencing text format
Hello everyone,
In my excelsheet I am referencing tables using VSTACK to create one master table, while keeping it easy to edit the original tables.
The problem that I am facing is that VSTACK does not use the text formatting of the referenced cells.
These are the source tables, and this is the master table:
I could manually make the headers the correct text format, but this format does not shift when a line is added or removed from a table, making the formatting shift incorrectly:
After manually adding formatting
adding a line (14 & 15) to the source table, and the text formatting stays on line 15 and 16 instead of shifting along with the text.
Is there a way to reference the text’s formatting so that the manual part of creating a master table can be fully automated? VSTACK does not have a parmater to keep formatting.
Hello everyone, In my excelsheet I am referencing tables using VSTACK to create one master table, while keeping it easy to edit the original tables. The problem that I am facing is that VSTACK does not use the text formatting of the referenced cells. These are the source tables, and this is the master table:I could manually make the headers the correct text format, but this format does not shift when a line is added or removed from a table, making the formatting shift incorrectly:After manually adding formattingadding a line (14 & 15) to the source table, and the text formatting stays on line 15 and 16 instead of shifting along with the text. Is there a way to reference the text’s formatting so that the manual part of creating a master table can be fully automated? VSTACK does not have a parmater to keep formatting. Read More
Bookings information not copying over to Outlook appointment
We have bookings and outlook to set up to go to our main calendar and then a copy of the appointment automatically goes to the individual calendar. The problem is that the Addition Information Section in the body of original appointment does not get copied over to the individual’s calendar. Due to changes made in Outlook last year, I can no longer change the body of the individual’s appointment. Our AI has to have the zoom link in the individuals appointment in order to connect to the meeting and that is what is missing. Short of having to manually add the zoom link into the hundreds of appointments, does anyone have any idea what solutions I have?
We have bookings and outlook to set up to go to our main calendar and then a copy of the appointment automatically goes to the individual calendar. The problem is that the Addition Information Section in the body of original appointment does not get copied over to the individual’s calendar. Due to changes made in Outlook last year, I can no longer change the body of the individual’s appointment. Our AI has to have the zoom link in the individuals appointment in order to connect to the meeting and that is what is missing. Short of having to manually add the zoom link into the hundreds of appointments, does anyone have any idea what solutions I have? Read More
Bad results – Ways of working
Hi team
I’ve just recently saw an specific case with one of our clients that has some issues creating the WoW report and I hope you can help us to identify if this is a problem that came after the April 2024 update.
As you can see the working hours are being showed like thousands and in some cases even the slide appears to have an error. We even regenerate a previous report (march) that was ok a month ago and right now it also broken.
Hi team I’ve just recently saw an specific case with one of our clients that has some issues creating the WoW report and I hope you can help us to identify if this is a problem that came after the April 2024 update. As you can see the working hours are being showed like thousands and in some cases even the slide appears to have an error. We even regenerate a previous report (march) that was ok a month ago and right now it also broken. Read More
the SQL server database engine cannot obtain a lock ressource at this time
hello
I have a problem with the configuration of SQL Server
I have SQL Server 2019 with the last cumulative update
i fixed the max server memory with 40000 Mo =40 Go
and maxdop to 0
i have enough disk space
the problem is when i execute this query :
(insert into table A select * from table B) this probleme happen
the instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.
but when i execute the same wuery like this ( select * into table A from table B ) the query work fine with no problem
Can anyone help me
thanx a lot
hello I have a problem with the configuration of SQL Server I have SQL Server 2019 with the last cumulative update i fixed the max server memory with 40000 Mo =40 Goand maxdop to 0 i have enough disk space the problem is when i execute this query : (insert into table A select * from table B) this probleme happen the instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.but when i execute the same wuery like this ( select * into table A from table B ) the query work fine with no problem Can anyone help me thanx a lot Read More
O365 Resource Room Delegate
My company recently had me setup a newly renovated meeting space as a resource room that required delegate approval to book. All of that is in place, and is working MOSTLY the way we would like it to. We have noticed however that pending resource requests still appear as tentative meetings (that end-users can join) prior to receiving delegate’s approval. This kind of defeats the purpose of adding a delegate approval requirement. Is there a way in powershell to prevent pending meetings from being viewable and/or joinable until they have actually been approved? Current settings below:
I was directed to post my question in this community instead of the O365 community.
My company recently had me setup a newly renovated meeting space as a resource room that required delegate approval to book. All of that is in place, and is working MOSTLY the way we would like it to. We have noticed however that pending resource requests still appear as tentative meetings (that end-users can join) prior to receiving delegate’s approval. This kind of defeats the purpose of adding a delegate approval requirement. Is there a way in powershell to prevent pending meetings from being viewable and/or joinable until they have actually been approved? Current settings below: I was directed to post my question in this community instead of the O365 community. Read More
Timestamp using VBA based on specific cell changes
Hi experts,
Hope you are well!
I am trying to get VBA to update a cell in one column with a timestamp of when another cell changes.
The attached code works well but when I use a filter on the spreadsheet, the code updates the timestamp to the current time when the actual cell has not been clicked or changed.
Is there anyway to better this code?
Function MyTimestamp(Reference As Range)
If Reference.Value <> “” Then
MyTimestamp = Format(Now, “dd-mm-yyyy hh:mm:ss”)
Else
MyTimestamp = “”
End If
End Function
See attached example
Thank you in advance
Matt
Hi experts,Hope you are well! I am trying to get VBA to update a cell in one column with a timestamp of when another cell changes. The attached code works well but when I use a filter on the spreadsheet, the code updates the timestamp to the current time when the actual cell has not been clicked or changed. Is there anyway to better this code? Function MyTimestamp(Reference As Range)
If Reference.Value <> “” Then
MyTimestamp = Format(Now, “dd-mm-yyyy hh:mm:ss”)
Else
MyTimestamp = “”
End If
End Function See attached example Thank you in advance Matt Read More
ACTION REQUIRED: New Agreement governing access to Hardware Dev Center
We have updated the agreements on Partner Center for the Windows Hardware Program. We made these updates to clarify our terms and ensure that they are transparent, as well as to address usage of new logos.
All participants in the Hardware Program are required to have their authorized personnel review, acknowledge, and accept the agreements. New submissions will be blocked after August 14, 2024 until the agreements are accepted.
Partners who have accepted prior versions of the agreement via other means will still need to accept the agreement on Partner Center. For partners who have already been a part of the program, you will see the previous agreement, the Windows Logo License Agreement from 2021, has been renamed and is now listed in the Agreements section of Partner Center as “Microsoft Marks License Agreement (formerly Windows Logo License Agreement)” with the value in the Agreement column of Version 2021.
As a result, partners who previously accepted the Windows Logo License Agreement will see two entries in the Agreements section:
The new Microsoft Marks License Agreement, with Version 2024.
The previous Windows Logo License Agreement, now renamed to “Microsoft Marks License Agreement (formerly Windows Logo License Agreement)” with the value in the Agreement column of Version 2021.
Going forward, the four agreements listed below will govern your access to the Hardware Program. Legacy agreements will be deprecated.
· Windows Hardware Compatibility Agreement
· Microsoft Marks License Agreement 2024 (New)
· Windows Analytics Agreement v2.0
If you encounter issues accessing the new agreements, please reach out to our support team. For details on how to contact support, see Get support for Partner Center dashboard issues – Windows drivers | Microsoft Learn.
Microsoft Tech Community – Latest Blogs –Read More
PART 3 – Ingesting AWS GovCloud Microsoft Sentinel in Azure Commercial
In the first part of this series Ingesting Non-Microsoft Cloud Security Data into Microsoft Sentinel for Government & DIB Customers we looked into the compliance levels of the clouds and the architecture of the AWS connector. In part 2 Ingesting Non-Microsoft Cloud Security Data into Microsoft Sentinel for Gov & DIB customers part 2 we walked thru setting up the connectors from AWS GovCloud and AWS into Microsoft Sentinel in Azure Government. In this blog we’ll discuss connecting AWS GovCloud into Microsoft Sentinel in Azure Commercial. We recognize that many Government and DIB customers use Azure Commercial and AWS GovCloud, so we’ve included the ability to monitor and respond to those cloud environments. Most of the same steps will apply, this will be very similar to part 2 so I’ve added more trouble shooting information in this part.
Installing the solution in Sentinel from Content Hub
First, we will open the Content Hub in Sentinel and search for “Amazon” to find the solution. The solution includes the S3 connector, 57 Analytic Rules, 36 Hunting Queries & 2 Workbooks.
Click install and the solution will install the connector and other parts of the solution. If you have already installed the Amazon Web Services solution, click on manage. Once the solution is installed You will be able to select the S3 Connector
The connector uses Windows PowerShell and AWS CLI to automate the setup required in AWS.
Configuring the installation environment
Prior to installing the connector using the PS1 script, you must properly configure the system you are using. If you have already done this skip forward to Running the ConfigueAwsConnector.ps1 Script section.
When running the script, ensure that you are using Windows PowerShell as there are Differences between Windows PowerShell and PowerShell 7.x – PowerShell.
Here is the link for installing PowerShell Install PowerShell on Windows, Linux, and macOS – PowerShell
AWS CLI installation is required by the configuration script to create the connections in AWS. Here is the link from Amazon to setup AWS CLI, AWS CLI Installation instructions.
The configuration script will confirm these settings when it runs. If this process returns any errors, check the *_accessKeys.csv file that you downloaded from AWS when you set up the access key, and ensure that the region is correct. In the AWS Console, the region displays US-Gov-West. You will need to update this to us-gov-west-1 when you run the AWS configure command or the script will throw an error.
Verified AWS access configuration
You will need to run the ConfigureAwsConnector.ps1 script. Depending on your organization’s policies, you may not be able to run the PowerShell script without setting the Windows PowerShell execution policy (using Set-ExecutionPolicy) to allow running unsigned scripts. You can check your policies by running.
PS C:> Get-ExecutionPolicy –List
If you need to change the policy run this command to allow running unsigned scripts
PS C:> Set-ExecutionPolicy -ExecutionPolicy Unrestricted
Once you are done installing the connections, you should set the execution policy back. More information about setting execution policies can be found on this page Execution Policies – PowerShell
Running the ConfigueAwsConnector.ps1 Script
To get started, download / extract the PowerShell script.
Make note of the log analytics workspace ID, this will be required when running the ConfigureAwsConnector.ps1 script. To further simplify this process, a Cloud Formation Template is in development. That information will be added to this blog series upon release.
In this example we are connecting VPC Flow logs.
The script will ask for the following information in order to setup the OpenID Connection ((OIDC)🙁
S3 bucket and will create one if needed.
Azure Workspace ID
SQS queue to be created.
Make a note of the information listed under “Role Arn”, “Sqs Queue”, and “Destination Table” as you will need this to configure the connection in Sentinel. On the connector page in Sentinel paste in the information
Enter the Role ARN, SQS URL & Destination table on the connector blade in Sentinel
Then select add connection. The first time you connect, you may see an error (ID25).
This is due to a test message the new SQS queue sends on first connection. The test message does not have the correct record that the connector is expecting and throws the error. Microsoft is working on either clarifying the error message or suppressing the error. When you click connect a second time and then the SQS queue sends the correct message, and the connection will be successful.
You can repeat this process for the other data types in AWS GovCloud. The connection process is the same for each data type. Guard Duty & Cloud Trail data types will ask if you want to use KMS. I used a different KMS for each data type just to keep things organized. Here is an example of what I used in my lab
Once you have all the connections setup you will start seeing data flowing. It might take a few minutes for data to come into Sentinel. This depends on amount of data AWS generates and when Sentinel communicates with the SQS queue. You should see a list of the connection on the Amazon S3 connector page in Sentinel.
Unique Scenario – Sending AWS Guard Duty data into both Azure Gov and Azure Commercial.
I found the scenario for ingesting one AWS account into two Sentinels due to the way my test lab and accounts were configured. I don’t think many customers will encounter this scenario, but I wanted to cover it just in case.
Since Guard Duty Settings it can only use a single bucket / SQS queue, it is not possible to send Guard Duty logs to 2 instances of Sentinel “out-of-the-box”. If you want to do this, you would have to add another Sentinel Workspace and possibly API path to the Trust Relationship Policy.
You will also have to find a way to handle the messages in the SQS queue. Since each Sentinel instance will pick up the messages and the other Sentinel instance may miss the message to get the logs.
If you want to send single AWS account data into 2 Sentinel instances this will require using something like a message bus and custom code. That discussion is beyond the scope of this blog.
Troubleshooting the connector –
In the second blog entry Ingesting Non-Microsoft Cloud Security Data into Microsoft Sentinel for Gov & DIB customers part 2 we investigated verifying data flow and querying it once it has been imported to Microsoft Sentinel. In this section, we will tackle troubleshooting unexpected issues. There are several places that are helpful to check in AWS while troubleshooting or to ensure that the script ran correctly:
S3 Bucket – logs and event notifications
VPC – Flow Logs
SQS queues
Cloud Trail
Guard Duty
S3 Buckets – Here, we will be looking for logs and event notifications. In the bucket you should see a folder called AWSLogs. Under that folder look for the folder with your account ID – you may also see a folder that starts with o-****. The folder that with o-*** is where organization logs may be. Look for the *.gz files, these are the actual logs.
Also check the Event Notifications & SQS queues on the bucket to ensure they were created
Check the Bucket Policy and check the OIDC Role
VPC Flow Logs – verify the Destination Name is the correct S3 bucket in the VPC configuration on the AWS console. Then you can verify that the folder mentioned above actually has *.gz files.
SQS Queues – Look on the monitoring tab and verify traffic on the monitor tab of the queue(s). If you don’t see any traffic here, then there might be an issue with the event notifications.
Verify the Access Policy has the correct OIDC role and permissions
Cloud Trail – Verify Trail settings in the Cloud Trail console-
Trail Log location under General Details. and the IAM Role on the Trail page.
AWS KMS key is correct
IAM Role in the CloudWatch Logs
Guard Duty – verify the S3 Protection is on
the correct S3 bucket is set correctly in the console- Guard Duty Settings
Summary
In this part of this series, we’ve walked through setting up the CLI and scripts required to establish the connection from AWS GovCloud into Microsoft Sentinel in Azure commercial and how can verify that the script setup the AWS resources correctly. You’re encouraged to explore the workbooks, analytics and hunting queries that are installed with the AWS Solution. These concepts can be explored in-depth with the helpful links below:
Visualize your data using workbooks in Microsoft Sentinel | Microsoft Learn.
Detect threats with analytics rule templates in Microsoft Sentinel | Microsoft Learn
Hunting capabilities in Microsoft Sentinel | Microsoft Learn
We just released the Multi Cloud Attack Essentials solution in the Sentinel Content Hub & GitHub. Here is the link to the repository Azure-Sentinel/Solutions/Multi Cloud Attack Coverage Essentials – Resource Abuse at master · Azure/Azure-Sentinel · GitHub
In our next blog, we will cover Google Cloud Platform (GCP) integration and the new Cloud Formation installation option for AWS.
Microsoft Tech Community – Latest Blogs –Read More
Speech to text?
Is there an app to allow users to do speech to text using CoPilot?
Is there an app to allow users to do speech to text using CoPilot? Read More
McAfee License has Expired pop out message
We recently had a Microsoft Defender desktop getting this scam popout message. After doing a little googling we think it is caused by a change in the browser that is allowing a push notification from a specific website. My question is why didn’t Defender detect this? I get that it was not malware but isn’t this something Defender should be a detect and alert about?
We recently had a Microsoft Defender desktop getting this scam popout message. After doing a little googling we think it is caused by a change in the browser that is allowing a push notification from a specific website. My question is why didn’t Defender detect this? I get that it was not malware but isn’t this something Defender should be a detect and alert about? Read More
Can my add-in for Excel be a transactable offer?
I’ve created an add-in for Excel that calculates the thermodynamic properties of water and steam. This would be useful for a number of industries and for university courses. My app has passed the Microsoft certification process. I know that a SaaS offer can be transactable (sold by Microsoft where they collect 3% of the sale and put the rest in your account). But I don’t see a similar option for when I created my Microsoft 365 Add-In Marketplace Offer on the Partner Center. Does anyone know if this is possible (make it a transactable offer) and how to go about it?
I’ve created an add-in for Excel that calculates the thermodynamic properties of water and steam. This would be useful for a number of industries and for university courses. My app has passed the Microsoft certification process. I know that a SaaS offer can be transactable (sold by Microsoft where they collect 3% of the sale and put the rest in your account). But I don’t see a similar option for when I created my Microsoft 365 Add-In Marketplace Offer on the Partner Center. Does anyone know if this is possible (make it a transactable offer) and how to go about it? Read More
What is the ID in the Booking Page URL?
Hello everyone,
I was wondering what that ID is that looks different in the URL for a bookin page depending on the user?
Any ideas and and how to find this information in an admin center?
Many thanks in advance
Hello everyone,I was wondering what that ID is that looks different in the URL for a bookin page depending on the user? Any ideas and and how to find this information in an admin center? Many thanks in advance Read More
Microsoft Partner Support (UK) – No answer
Hi
I’m trying to reach someone in Partner Support however all attempts lead nowhere.
I’ve opened cases and they have been closed automatically without being fully answered.
I’ve tried to use the Partner Support Options located here: https://support.microsoft.com/en-gb/topic/partner-support-options-6e2fefd9-4adf-2be1-9968-165aa84b1c3b
Support by phone takes you to the usual process for opening a case, this does not provide an option in the list for the problem I’m having. It also does seem to just result in opening a new case so I’m back where I started and no phone number provided.
If I click chat online with an agent I get the following:
I am logged in to my partner account, I have tried multiple computers.
I also tried calling the regular Microsoft Support number here in the UK 0344 800 2400 but it is an entirely automated service. It doesn’t understand my request and also doesn’t allow you to speak with an actual person.
Is anyone else having the same trouble?
HiI’m trying to reach someone in Partner Support however all attempts lead nowhere.I’ve opened cases and they have been closed automatically without being fully answered. I’ve tried to use the Partner Support Options located here: https://support.microsoft.com/en-gb/topic/partner-support-options-6e2fefd9-4adf-2be1-9968-165aa84b1c3b Support by phone takes you to the usual process for opening a case, this does not provide an option in the list for the problem I’m having. It also does seem to just result in opening a new case so I’m back where I started and no phone number provided. If I click chat online with an agent I get the following:I am logged in to my partner account, I have tried multiple computers. I also tried calling the regular Microsoft Support number here in the UK 0344 800 2400 but it is an entirely automated service. It doesn’t understand my request and also doesn’t allow you to speak with an actual person. Is anyone else having the same trouble? Read More
VBA Compile Error for each control variable must be variant or object
I have a vba code I am having issues with. The way it’s supposed to function is a userform opens when the button is pressed. In the UF, there are four checkboxes: A only, B only, C only, and D only each of which should be selected if the user’s data will contain that column (know as the master column). If so, the user is to enter the column letter it starts at in the text box next to it. Once the checkbox is clicked, a list of the potential column letters for the subcategories appears so the user can select where the data from the master column letter should be outputted into. Each Master column has a range it could fall into. When I run the code, nothing outputs.
Thanks in advance for any help!
I attached the sample document below. I also include the code that runs but doesn’t process any data. then i commented the updated one that gives me the compile error:
I have a vba code I am having issues with. The way it’s supposed to function is a userform opens when the button is pressed. In the UF, there are four checkboxes: A only, B only, C only, and D only each of which should be selected if the user’s data will contain that column (know as the master column). If so, the user is to enter the column letter it starts at in the text box next to it. Once the checkbox is clicked, a list of the potential column letters for the subcategories appears so the user can select where the data from the master column letter should be outputted into. Each Master column has a range it could fall into. When I run the code, nothing outputs. Thanks in advance for any help! Codes for the userform:Private Sub chboxA_Click() TextBox1.Enabled = chboxA.Value ‘ Toggle the enabling of TextBox1 based on chboxA’s state lstA.Visible = chboxA.Value ‘ Toggle the visibility of lstA based on chboxA’s stateEnd Sub Private Sub chboxB_Click() TextBox2.Enabled = chboxB.Value ‘ Toggle the enabling of TextBox2 based on chboxB’s state lstB.Visible = chboxB.Value ‘ Toggle the visibility of lstB based on chboxB’s stateEnd Sub Private Sub chboxC_Click() TextBox3.Enabled = chboxC.Value ‘ Toggle the enabling of TextBox3 based on chboxC’s state lstC.Visible = chboxC.Value ‘ Toggle the visibility of lstC based on chboxC’s stateEnd Sub Private Sub chboxD_Click() TextBox4.Enabled = chboxD.Value ‘ Toggle the enabling of TextBox4 based on chboxD’s state lstD.Visible = chboxD.Value ‘ Toggle the visibility of lstD based on chboxD’s stateEnd Sub Private Sub UserForm_Initialize() ‘ Initialize ListBoxes with columns Dim col As Variant For Each col In Array(“lstA”, “lstB”, “lstC”, “lstD”) With Me.Controls(col) .List = Array(“I”, “J”, “K”, “L”, “M”, “N”, “O”, “P”, “Q”, “R”, “S”, “T”, “U”, “V”, “W”) .MultiSelect = fmMultiSelectMulti .Visible = False ‘ Initialize all ListBoxes as hidden End With Next col ‘ Initialize the visibility based on checkboxes lstA.Visible = chboxA.Value lstB.Visible = chboxB.Value lstC.Visible = chboxC.Value lstD.Visible = chboxD.Value TextBox1.Enabled = chboxA.Value TextBox2.Enabled = chboxB.Value TextBox3.Enabled = chboxC.Value TextBox4.Enabled = chboxD.ValueEnd Sub Private Sub cmdProcessData_Click() Application.ScreenUpdating = False ‘ Disable screen updating to enhance performance Application.Calculation = xlCalculationManual ‘ Avoid recalculation until the end for performance Dim ws As Worksheet Set ws = ThisWorkbook.Sheets(“BidTrial”) Dim i As Integer Dim targetCols As String Dim masterCol As String Dim colLetter As String For i = 1 To 4 ‘ Check if the corresponding checkbox is checked If Me.Controls(“chbox” & Chr(64 + i)).Value Then colLetter = Me.Controls(“TextBox” & i).Text ‘ Validate the column letter is correct and only allow single column letters If colLetter <> “” And IsColumnValid(colLetter) Then masterCol = colLetter & “10:” & colLetter & “121” ‘ Data starts at row 10 targetCols = GetSelectedRanges(Me.Controls(“lst” & Chr(64 + i))) ‘ Copy data from master column to selected target columns If targetCols <> “” Then CopyData ws, masterCol, targetCols End If Else MsgBox “Invalid column letter in TextBox” & i, vbExclamation End If End If Next i Application.Calculate ‘ Recalculate all formulas in the workbook Application.ScreenUpdating = True ‘ Re-enable screen updating MsgBox “Data processing complete!”End Sub Function IsColumnValid(col As String) As Boolean IsColumnValid = (col >= “A” And col <= “W”) And Len(col) = 1 ‘ Ensure single letter between A and WEnd Function Function GetSelectedRanges(lstBox As MSForms.ListBox) As String Dim result As String Dim i As Integer For i = 0 To lstBox.ListCount – 1 If lstBox.selected(i) Then If result <> “” Then result = result & “,” result = result & lstBox.List(i) & “10:” & lstBox.List(i) & “121” ‘ Specify full range for each selected column End If Next i GetSelectedRanges = resultEnd Function Sub CopyData(ws As Worksheet, masterCol As String, targetCols As String) Dim targetRange As Range, cell As Range, targetCell As Range Dim colRange As Variant For Each colRange In Split(targetCols, “,”) Set targetRange = ws.Range(colRange) For Each cell In ws.Range(masterCol) If Not IsGrey(cell) And Not IsEmpty(cell.Value) Then For Each targetCell In targetRange If Not IsGrey(targetCell) Then targetCell.Value = cell.Value End If Next targetCell End If Next cell Next colRangeEnd Sub Function IsGrey(cell As Range) As Boolean IsGrey = (cell.Interior.Color = RGB(128, 128, 128)) ‘ Check if the cell’s color is greyEnd Function This is how my data looks and where it should be outputted into. For example, since A only has data, the user would enter H in the text box, then select each column that has A in it (L:O). Then the code would copy the data in H into those columns. For B only, the same would occur but only for headers with B (L:N). The code runs, but does not output. When I try to update the copydata to this: Sub CopyData(ws As Worksheet, masterCol As String, targetCols As String) Dim targetRange As Range, cell As Range, targetCell As Range Dim colRange As String ‘ Ensure that colRange is treated as a String here For Each colRange In Split(targetCols, “,”) Set targetRange = ws.Range(colRange) For Each cell In ws.Range(masterCol) If Not IsGrey(cell) And Not IsEmpty(cell.Value) Then For Each targetCell In targetRange.Cells ‘ Make sure to iterate over Cells of targetRange If Not IsGrey(targetCell) Then targetCell.Value = cell.Value End If Next targetCell End If Next cell Next colRangeEnd Sub When I update the code, I tend to have issues with it running due to For Each colRange In Split(targetCols, “,”). It’s being used as a variant because of it iterating over an array resulting from the split function, however, there seems to be inconsistencies in how vba is handling it. Not sure how to fix it.: I attached the sample document below. I also include the code that runs but doesn’t process any data. then i commented the updated one that gives me the compile error: Sub CopyData(ws As Worksheet, masterCol As String, targetCols As String) Dim targetRange As Range, cell As Range, targetCell As Range Dim colRange As String ‘ Ensure that colRange is treated as a String here For Each colRange In Split(targetCols, “,”) Set targetRange = ws.Range(colRange) For Each cell In ws.Range(masterCol) If Not IsGrey(cell) And Not IsEmpty(cell.Value) Then For Each targetCell In targetRange.Cells ‘ Make sure to iterate over Cells of targetRange If Not IsGrey(targetCell) Then targetCell.Value = cell.Value End If Next targetCell End If Next cell Next colRangeEnd Sub Read More
M365 Community Conference: The Intranet of Tomorrow – Beautiful, Flexible, and AI-ready
Session: The intranet of tomorrow: beautiful, flexible, and AI-ready
Speakers: Denise Trabona, Dave Cohen
The 2024 edition of the Microsoft 365 Community Conference had so many great sessions delivering insights and innovations, particularly this session on the intranet of tomorrow.
Denise Trabona and Dave Cohen led an interesting session detailing the future of the SharePoint-based intranet. They detailed how the intranet needs to be engaging, flexible, AI-ready and aligned with the web standards and the organization’s brand identity. The emphasis is on a user-centric design that ensures ease of navigation, personalized content delivery, and a cohesive experience across all devices.
Compelling content features
Denise showed new capabilities for engaging typography, color, hero web part, section backgrounds, image shapes, animation, video, and motion that will make the intranet content more visually appealing and memorable.
The new capabilities with images and video are impressive and will truly bring pages to life. Anyone can be a creator on the intranet – it’s not required to have extensive design training to create wonderful content.
Soon organizations will have the ability to bring custom font families into SharePoint Online using the new Brand Center. Page creators will be able to preview how the fonts look on the page and adjust as needed before applying to the site. Design ideas functionality, like in Microsoft PowerPoint, is coming to SharePoint as well. This will give options to authors to help inspire great looking pages using the content you have in a section, without any extensive design knowledge needed.
Another notable feature coming is flexible layouts. This feature will allow even more choices than the standard ones we have now, and smart ‘magnetic’ anchors will help align content. Dragging the section vertical size and the content within it was a big hit when shown as well! The other crowd pleaser was when coauthoring SharePoint pages was shown. The ability to work on a page at the same time as another author is amazing and will help content teams get the content finished more quickly.
SharePoint Start
SharePoint Start is the place to create new SharePoint pages but without the need for a site to host the page. The pages are technically stored in the user’s OneDrive but will be inaccessible to the user via the files viewer. The pages will be shown on SharePoint Start and will be sharable. The pages can be copied to a SharePoint site if needed afterwards, with the move function also coming.
This feature is designed to reduce barriers – creation of a site – to create content pages. The pages will have full capabilities just like you have when creating on a site.
The era of AI
The conference had a heavy emphasis on Copilot in Microsoft 365, which is understandable. This session was no different, due mostly to the fact that a substantial part of the grounding of Copilot is in SharePoint content. Combining the power of Microsoft’s Large Language Model and your content’s information, Copilot will use SharePoint’s content to power the knowledge in your organization. Using Copilot Studio, it is easy to create solutions that will use specific SharePoint sites for grounding for answers, acronyms, and more. Coming soon, we will also have more Copilot functionality joined with SharePoint, saving users time when creating and managing content.
Collaboration is the heartbeat of any organization, and the intranet of tomorrow is designed to enhance this. With advanced features that facilitate real-time collaboration and communication, teams can work together more effectively, regardless of their physical location!
Microsoft Tech Community – Latest Blogs –Read More
What To Do When Stuck in QuickBooks administrator permissions needed Issue?
Troubleshooting Solutions: QuickBooks administrator permissions needed
Verify Administrator Status: Ensure that your QuickBooks account has been designated as an administrator. Go to the User List within QuickBooks and confirm that your account has administrative privileges. If not, have an existing administrator grant you these permissions.
Recheck User Permissions: Review the specific permissions assigned to your account. Navigate to the User List and adjust permissions accordingly, granting access to areas and functions essential for your role.
User Access Rights: Confirm that the specific tasks or features you’re trying to access are within the scope of your user access rights. QuickBooks offers granular control over user permissions, so ensure you have the necessary rights for the tasks you need to perform.
Company File Permissions: Check the permissions set for the company file itself. Make sure it hasn’t been set to read-only or restricted access, which could prevent you from making changes or accessing certain features.
Firewall and Antivirus Settings: Verify that your firewall or antivirus software isn’t blocking QuickBooks from accessing necessary resources. Adjust settings as needed to allow QuickBooks full access to function properly.
Update QuickBooks: Ensure that you are using the latest version of QuickBooks. Updates often include bug fixes and security patches that may resolve permission-related issues.
Data Corruption: If none of the above solutions work, there might be data corruption within the QuickBooks file. Attempt to restore a backup copy of the file from before the issue started occurring.
Consult QuickBooks Support: If the problem persists, consider reaching out to QuickBooks support for further assistance. They can provide specialized guidance tailored to your specific issue and may have additional troubleshooting steps.
Review Audit Trail: Check the audit trail within QuickBooks to see if any recent changes have affected permissions. This can help identify if the issue stems from a recent adjustment or action within the software.
By following these troubleshooting steps, you should be able to diagnose and resolve the QuickBooks administrator permissions needed issue, restoring full functionality to your account.
Troubleshooting Solutions: QuickBooks administrator permissions needed Verify Administrator Status: Ensure that your QuickBooks account has been designated as an administrator. Go to the User List within QuickBooks and confirm that your account has administrative privileges. If not, have an existing administrator grant you these permissions.Recheck User Permissions: Review the specific permissions assigned to your account. Navigate to the User List and adjust permissions accordingly, granting access to areas and functions essential for your role.User Access Rights: Confirm that the specific tasks or features you’re trying to access are within the scope of your user access rights. QuickBooks offers granular control over user permissions, so ensure you have the necessary rights for the tasks you need to perform.Company File Permissions: Check the permissions set for the company file itself. Make sure it hasn’t been set to read-only or restricted access, which could prevent you from making changes or accessing certain features.Firewall and Antivirus Settings: Verify that your firewall or antivirus software isn’t blocking QuickBooks from accessing necessary resources. Adjust settings as needed to allow QuickBooks full access to function properly.Update QuickBooks: Ensure that you are using the latest version of QuickBooks. Updates often include bug fixes and security patches that may resolve permission-related issues.Data Corruption: If none of the above solutions work, there might be data corruption within the QuickBooks file. Attempt to restore a backup copy of the file from before the issue started occurring.Consult QuickBooks Support: If the problem persists, consider reaching out to QuickBooks support for further assistance. They can provide specialized guidance tailored to your specific issue and may have additional troubleshooting steps.Review Audit Trail: Check the audit trail within QuickBooks to see if any recent changes have affected permissions. This can help identify if the issue stems from a recent adjustment or action within the software. By following these troubleshooting steps, you should be able to diagnose and resolve the QuickBooks administrator permissions needed issue, restoring full functionality to your account. Read More