Month: July 2024
Default Authentication Policy – does not apply to mailboxes where AuthenticationPolicy = $null
I need to verify this in another tenant, but I’ve always assumed as per the docs that if an authentication policy is not set on a mailbox, that it assumes the policy that is set as the default org policy. However, I’ve just had a user being password sprayed from the usual countries via SMTP, evidenced in the sign-in logs (lots of ‘failed’ entries). The users auth policy was null. I then set the auth policy to the ‘default’ (which was already set as the default in the org settings) and this appears to have stopped the SMTP sign-in attempts. Can anyone verify this? Has there been a change to the behaviour? Any insights appreciated.
I need to verify this in another tenant, but I’ve always assumed as per the docs that if an authentication policy is not set on a mailbox, that it assumes the policy that is set as the default org policy. However, I’ve just had a user being password sprayed from the usual countries via SMTP, evidenced in the sign-in logs (lots of ‘failed’ entries). The users auth policy was null. I then set the auth policy to the ‘default’ (which was already set as the default in the org settings) and this appears to have stopped the SMTP sign-in attempts. Can anyone verify this? Has there been a change to the behaviour? Any insights appreciated. Read More
Multiparty private offers now available in the UK and Canada
Multiparty private offers, which allows partners to co-sell through the marketplace framework, are now available in the United Kingdom and Canada, in addition to the United States.
The cloud marketplace opportunity is projected to reach $45 billion by next year, with a third of this revenue driven by channel partners. Microsoft’s ecosystem includes over 500,000 partners, and Microsoft is focused on enhancing collaborative selling. Multiparty private offers enable channel partners to procure solutions on behalf of customers, streamlining the sales process and counting the entire purchase towards a customer’s Azure consumption commitment. This approach not only maximizes customer investments but also encourages larger transactions, with sales involving multiparty private offers averaging double the size of standard private offers.
The process of creating and executing multiparty private offers involves collaboration between ISV and channel partners to identify the right solution and negotiate terms. The ISV extends a private offer to the channel partner, who then adds their details to create a multiparty private offer. The channel partner presents the offer to the customer, who accepts and purchases it as they would a private offer from an ISV. For Azure consumption commitment customers, eligible purchases contribute towards their commitment. Microsoft handles the payment collection and ensures partners are compensated.
Channel partners can resell an ISV’s solution—provided they operate within a qualified geographic region. Currently, multiparty private offers are available to customers in the United States, Canada, and the United Kingdom. There are plans to extend the availability to more regions—starting with Western Europe and Japan in the near future.
To learn more about the expansion of multiparty private offers, check out this blog: Activating the ecosystem: marketplace multiparty private offers expand to new regions
Have you already sold or are planning to sell through multiparty private offers? Comment below to share your feedback!
Multiparty private offers, which allows partners to co-sell through the marketplace framework, are now available in the United Kingdom and Canada, in addition to the United States.
The cloud marketplace opportunity is projected to reach $45 billion by next year, with a third of this revenue driven by channel partners. Microsoft’s ecosystem includes over 500,000 partners, and Microsoft is focused on enhancing collaborative selling. Multiparty private offers enable channel partners to procure solutions on behalf of customers, streamlining the sales process and counting the entire purchase towards a customer’s Azure consumption commitment. This approach not only maximizes customer investments but also encourages larger transactions, with sales involving multiparty private offers averaging double the size of standard private offers.
The process of creating and executing multiparty private offers involves collaboration between ISV and channel partners to identify the right solution and negotiate terms. The ISV extends a private offer to the channel partner, who then adds their details to create a multiparty private offer. The channel partner presents the offer to the customer, who accepts and purchases it as they would a private offer from an ISV. For Azure consumption commitment customers, eligible purchases contribute towards their commitment. Microsoft handles the payment collection and ensures partners are compensated.
Channel partners can resell an ISV’s solution—provided they operate within a qualified geographic region. Currently, multiparty private offers are available to customers in the United States, Canada, and the United Kingdom. There are plans to extend the availability to more regions—starting with Western Europe and Japan in the near future.
To learn more about the expansion of multiparty private offers, check out this blog: Activating the ecosystem: marketplace multiparty private offers expand to new regions
Have you already sold or are planning to sell through multiparty private offers? Comment below to share your feedback!
Read More
Using functions to calculate hours in an Excel schedule
Hello, I’m going to try to explain what I’m looking for, so please be patient as I’m not particularly well versed in function commands for Excel. I am attempting to optimize a work schedule template that we use Excel for so that it calculates the hours an employee works in a given week. In the mock up below, I want to be able to calculate the total hours an employee works (let’s say John, for example) in a week, despite them working a variety of days/hours (New York, Boston, etc.). I’m trying to get Excel to search for all instances of John’s name in the chart from D4 to H21 and calculate the value of each cell that his name appears in. So in this example, John works an 8 hour New York run, an 8 hour Boston run, a 6 hour LA run, a 6 hour New Orleans run and a 5 hour Philadelphia run. I want to try to get the red box next to his name to display the total 33 hours that he worked for the week. I believe the SUMIF function will help me accomplish this, but so far when I attempt this with a function template I found on another forum (=SUMIF(D4:H21,”John”,C4:C21), I get only the Mondays work for some people and 0’s for others. I’m not entirely sure what the issue is here, or if I’m just asking too much of Excel. Hopefully I’ve explained this coherently and any input here would be very helpful. Thank you.
Hello, I’m going to try to explain what I’m looking for, so please be patient as I’m not particularly well versed in function commands for Excel. I am attempting to optimize a work schedule template that we use Excel for so that it calculates the hours an employee works in a given week. In the mock up below, I want to be able to calculate the total hours an employee works (let’s say John, for example) in a week, despite them working a variety of days/hours (New York, Boston, etc.). I’m trying to get Excel to search for all instances of John’s name in the chart from D4 to H21 and calculate the value of each cell that his name appears in. So in this example, John works an 8 hour New York run, an 8 hour Boston run, a 6 hour LA run, a 6 hour New Orleans run and a 5 hour Philadelphia run. I want to try to get the red box next to his name to display the total 33 hours that he worked for the week. I believe the SUMIF function will help me accomplish this, but so far when I attempt this with a function template I found on another forum (=SUMIF(D4:H21,”John”,C4:C21), I get only the Mondays work for some people and 0’s for others. I’m not entirely sure what the issue is here, or if I’m just asking too much of Excel. Hopefully I’ve explained this coherently and any input here would be very helpful. Thank you. Read More
Simulating Multiple Reviewers to Collate Changes in a Document
I have a very long document in which I’m tracking multiple discrete batches of changes, and I’d like to be able to effectively turn one or more batches on or off by assigning a “reviewer” to each batch of changes and then using “Show Markup -> Specific People” to select which I want to see.
My problem is I can’t figure out how to simulate different users when making batches of changes from the same account. Any ideas?
I have a very long document in which I’m tracking multiple discrete batches of changes, and I’d like to be able to effectively turn one or more batches on or off by assigning a “reviewer” to each batch of changes and then using “Show Markup -> Specific People” to select which I want to see. My problem is I can’t figure out how to simulate different users when making batches of changes from the same account. Any ideas? Read More
Filter working and then only partially working
I have been using filters on my spreadsheet and they were working fine and then all of a sudden it would only partially work – for example, I have a row that I have drop down options: Ok, To Query, Queried, Resolved. If I filtered the row to find only OK, when it is partially working, it would include all the ‘OK’s, but then some Queried, etc.
I couldn’t figure out why this was happening so I made a new spreadsheet and copied everything over. Again, it was working all fine for a while, and then all of a sudden it stopped filtering properly again.
I am not sure what is happening.
I have attached a screenshot of the specific row in my spreadsheet – it is filtered on OK
I have been using filters on my spreadsheet and they were working fine and then all of a sudden it would only partially work – for example, I have a row that I have drop down options: Ok, To Query, Queried, Resolved. If I filtered the row to find only OK, when it is partially working, it would include all the ‘OK’s, but then some Queried, etc. I couldn’t figure out why this was happening so I made a new spreadsheet and copied everything over. Again, it was working all fine for a while, and then all of a sudden it stopped filtering properly again. I am not sure what is happening. I have attached a screenshot of the specific row in my spreadsheet – it is filtered on OK Read More
Using Query Store to Capture PostgreSQL Performance in Azure Database | Data Exposed: MVP Edition
Capturing query metrics in PostgreSQL can be a challenge. Add in running that PostgreSQL database on Azure and things get even more challenging. However, Microsoft has a great addition to PostgreSQL when running in Azure Database, Query Store. This session will show the great query information available within the Query Store and how to query it.
Resources:
Query Store – Azure Database for PostgreSQL – Flexible Server
Using Azure Query Store to Understand PostgreSQL Performance
Query Store best practices – Azure Database for PostgreSQL – Flexible Server
About Grant Fritchey:
Grant Fritchey works for Red Gate Software as a Product Advocate. Grant has more than 30 years of experience in the industry as a DBA and developer. Grant has written many books including “SQL Server 2022 Query Performance Tuning”. Grant teaches classes on data management and databases to the smallest user groups and largest events, all around the world.
About MVPs:
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the “bleeding edge” and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others – that’s what sets them apart. Learn more.
View/share our latest episodes on Microsoft Learn and YouTube!
Microsoft Tech Community – Latest Blogs –Read More
Try out the new Copilot in Planner (preview) today in the new Microsoft Planner in Teams
We are excited to share that Copilot in Planner (preview) is now rolled out to 100% of users with a Project Plan 3 or Project Plan 5 license* in Microsoft Planner in Teams. With the power of generative AI, Copilot in Planner streamlines the planning, management, and execution of your work, keeping you informed as you achieve your goals.
Over the last few weeks as we started rolling out Copilot in Planner we’ve received tremendous feedback from early users. Thank you! We value your feedback and have been incorporating it into product improvements. Recent updates include:
• The ability to return to previous chats and improved reliability in answering questions about progress, due dates, and assignments
• Enhancements in adding subtasks and linking tasks to buckets and goals
• New suggested prompts to highlight question and answer capabilities
In the coming weeks, users can expect the ability to build a plan – including goals, buckets, and a work breakdown – with a single prompt.
Explore Copilot in Planner (preview) for planning, managing, and tracking projects:
• Planning: Copilot assists teams in setting goals, breaking down work, and generating tasks, goals, and buckets based on user prompts, facilitating the creation of a comprehensive project plan.
• Effective Execution: Copilot helps streamline processes, identify next steps, and break down large tasks. It manages collaboration, tracks new goals, and identifies workload issues among team members.
• Tracking Progress: Copilot aids in tracking complex plans by quickly surfacing necessary information about progress, priorities, and workload, ensuring teams stay informed and on track.
Get started
If you already have a Project Plan 3 or Project Plan 5 license, you can preview Copilot in Planner capabilities*.
If you do not have a Project license, you can request a free 30-day trial. Simply click on the diamond icon within the Planner app in Teams where you can begin your free 30-day trial of advanced capabilities of Planner including Copilot in Planner or proceed with requesting a premium license.
Share your feedback
You can share feedback through the new Planner app in Teams directly. You can also send us your feedback via the Planner Feedback Portal.
Here is how you can share your feedback directly from within the new Planner app.
Resources
• Explore the new Day in the Life guides to use Planner and Copilot for individual task management, collaborative work management and project management.
• Watch the new Planner demos for inspiration on how to get the most out of the new Planner app in Microsoft Teams.
• Bookmark the new Planner adoption website
• We’ve got a lot more ‘planned’ for the new Planner this year! Stay tuned to the Planner Blog – Microsoft Community Hub for news.
• For Planner feature updates, visit the Microsoft 365 roadmap here
• Learn about Planner and Project plans and pricing here
• Read the FAQs here
Requirements
In general, Copilot supports the following languages for prompts: Chinese (Simplified), English, French, German, Italian, Japanese, Portuguese (Brazil), Spanish. We plan on to add more languages to Copilot and will update as additional languages are supported.
* While final pricing for Copilot in Planner has not been announced, users with a Project Plan 3 or Project Plan 5 license can preview Copilot in Planner capabilities.
Microsoft Tech Community – Latest Blogs –Read More
How to plot cross quantile correltaion heatmap
How do I plot similar cross quantile correlation plotHow do I plot similar cross quantile correlation plot How do I plot similar cross quantile correlation plot heatmap, quantile, correlat MATLAB Answers — New Questions
i am trying to open matlab but it is showing “You dont have a valid license file”. It was working fine before.
i am trying to open matlab but it is showing "You dont have a valid license file". It was working fine before.i am trying to open matlab but it is showing "You dont have a valid license file". It was working fine before. i am trying to open matlab but it is showing "You dont have a valid license file". It was working fine before. valid license file MATLAB Answers — New Questions
py.list bug in R2024a
I believe I’m experiencing a bug in R2024a with py.list. After a clear all, I get the error No module or function named ‘list’.:
clear all;res = py.list({"Name1","Name2","Name3"});
In this interface, the code runs just fine. When I run it locally, I get this:
>> clear all;res = py.list({"Name1","Name2","Name3"})
No module or function named ‘list’.
I can get py.list to work again if I use another Python command. For example, this works:
>> handlers = py.logging.getLogger().handlers;
>> res = py.list({"Name1","Name2","Name3"});
>> clear all;res = py.list({"Name1","Name2","Name3"});
No module or function named ‘list’.
I’m running MATLAB Version: 24.1.0.2628055 (R2024a) Update 4. I cannot replicate on R2023b.I believe I’m experiencing a bug in R2024a with py.list. After a clear all, I get the error No module or function named ‘list’.:
clear all;res = py.list({"Name1","Name2","Name3"});
In this interface, the code runs just fine. When I run it locally, I get this:
>> clear all;res = py.list({"Name1","Name2","Name3"})
No module or function named ‘list’.
I can get py.list to work again if I use another Python command. For example, this works:
>> handlers = py.logging.getLogger().handlers;
>> res = py.list({"Name1","Name2","Name3"});
>> clear all;res = py.list({"Name1","Name2","Name3"});
No module or function named ‘list’.
I’m running MATLAB Version: 24.1.0.2628055 (R2024a) Update 4. I cannot replicate on R2023b. I believe I’m experiencing a bug in R2024a with py.list. After a clear all, I get the error No module or function named ‘list’.:
clear all;res = py.list({"Name1","Name2","Name3"});
In this interface, the code runs just fine. When I run it locally, I get this:
>> clear all;res = py.list({"Name1","Name2","Name3"})
No module or function named ‘list’.
I can get py.list to work again if I use another Python command. For example, this works:
>> handlers = py.logging.getLogger().handlers;
>> res = py.list({"Name1","Name2","Name3"});
>> clear all;res = py.list({"Name1","Name2","Name3"});
No module or function named ‘list’.
I’m running MATLAB Version: 24.1.0.2628055 (R2024a) Update 4. I cannot replicate on R2023b. python MATLAB Answers — New Questions
Fit meta data to a custom equation
Hello everyone,
I have been having trouble fitting a set of meta data (attached called IndiMSD) to this custom equation, doing fit to a custom equation and output parameters of the equation.
The first row of data points of x and y is zero, it will output Inf of NaN when do the fit. So I disgard all in x and y matrix.
now the x and y are below:
x_input = readmatrix(‘IndiMSD.xlsx’);
x = x_input(2:end,:); % first zero rows are disgarded, now x is 96 by 112, instead of 97 by 112
y = 15:15:1440;% first zero data point is disgarded, now y is 96 by 1
I want to fit each paif of column of x with y as above. For example, x(:,1) will be fitted with y, output its own S, P value with goodness of fit; , x(:,2) fits with y, output its own S, P value with goodness of fit, and so on until the last column. All fitted results of S, P and goodness of fit will be stored in separate matrice.
The fitted equation is
y = 2*((S^2)*(P^2)) * ((x./P) – 1 + exp(-(x./P)));
I really appreciate it if anyone has some ideas of how to do it.Hello everyone,
I have been having trouble fitting a set of meta data (attached called IndiMSD) to this custom equation, doing fit to a custom equation and output parameters of the equation.
The first row of data points of x and y is zero, it will output Inf of NaN when do the fit. So I disgard all in x and y matrix.
now the x and y are below:
x_input = readmatrix(‘IndiMSD.xlsx’);
x = x_input(2:end,:); % first zero rows are disgarded, now x is 96 by 112, instead of 97 by 112
y = 15:15:1440;% first zero data point is disgarded, now y is 96 by 1
I want to fit each paif of column of x with y as above. For example, x(:,1) will be fitted with y, output its own S, P value with goodness of fit; , x(:,2) fits with y, output its own S, P value with goodness of fit, and so on until the last column. All fitted results of S, P and goodness of fit will be stored in separate matrice.
The fitted equation is
y = 2*((S^2)*(P^2)) * ((x./P) – 1 + exp(-(x./P)));
I really appreciate it if anyone has some ideas of how to do it. Hello everyone,
I have been having trouble fitting a set of meta data (attached called IndiMSD) to this custom equation, doing fit to a custom equation and output parameters of the equation.
The first row of data points of x and y is zero, it will output Inf of NaN when do the fit. So I disgard all in x and y matrix.
now the x and y are below:
x_input = readmatrix(‘IndiMSD.xlsx’);
x = x_input(2:end,:); % first zero rows are disgarded, now x is 96 by 112, instead of 97 by 112
y = 15:15:1440;% first zero data point is disgarded, now y is 96 by 1
I want to fit each paif of column of x with y as above. For example, x(:,1) will be fitted with y, output its own S, P value with goodness of fit; , x(:,2) fits with y, output its own S, P value with goodness of fit, and so on until the last column. All fitted results of S, P and goodness of fit will be stored in separate matrice.
The fitted equation is
y = 2*((S^2)*(P^2)) * ((x./P) – 1 + exp(-(x./P)));
I really appreciate it if anyone has some ideas of how to do it. nonlinear, curve fitting MATLAB Answers — New Questions
VideoReader: Unrecognized function or variable ‘hasFrame’
I am following the VideoReader documentation from https://www.mathworks.com/help/matlab/ref/videoreader.html
When I try to run the example code using R2024a Update 5,
currAxes = axes;
v = VideoReader("xylophone_video.mp4");
while hasFrame(v)
vidFrame = readFrame(v);
image(vidFrame,"Parent",currAxes)
currAxes.Visible = "off";
pause(1/v.FrameRate)
end
the line with while hasFrame(v) throws an error: Unrecognized function or variable ‘hasFrame’.
The VideoReader object was created, but the hasFrame(v) line does not work. Was support for this function removed? If so, what replaced it?I am following the VideoReader documentation from https://www.mathworks.com/help/matlab/ref/videoreader.html
When I try to run the example code using R2024a Update 5,
currAxes = axes;
v = VideoReader("xylophone_video.mp4");
while hasFrame(v)
vidFrame = readFrame(v);
image(vidFrame,"Parent",currAxes)
currAxes.Visible = "off";
pause(1/v.FrameRate)
end
the line with while hasFrame(v) throws an error: Unrecognized function or variable ‘hasFrame’.
The VideoReader object was created, but the hasFrame(v) line does not work. Was support for this function removed? If so, what replaced it? I am following the VideoReader documentation from https://www.mathworks.com/help/matlab/ref/videoreader.html
When I try to run the example code using R2024a Update 5,
currAxes = axes;
v = VideoReader("xylophone_video.mp4");
while hasFrame(v)
vidFrame = readFrame(v);
image(vidFrame,"Parent",currAxes)
currAxes.Visible = "off";
pause(1/v.FrameRate)
end
the line with while hasFrame(v) throws an error: Unrecognized function or variable ‘hasFrame’.
The VideoReader object was created, but the hasFrame(v) line does not work. Was support for this function removed? If so, what replaced it? video processing MATLAB Answers — New Questions
OWA loop after Exchange 2019 enabling Extended Protection
Has anyone encountered before?
Scenario
Exchange environment is Exchange 2016 & Exchange 2019.Exchange 2016 – Extended Protection not enabledExchange 2019 – Extended Protection enabled.User mailbox is residing in Exchange 2019 User attempt to login via OWA (FBA) on Exchange 2016 When login, the page keeps looping back to the logon screen.
Error in httproxy owa logs: WebExceptionStatus=ProtocolError;ResponseStatusCode=401;WebException=System.Net.WebException: The remote server returned an error: (401) Unauthorized.
Attempted to login to both OWA & ECP via OWA on Exchange 2019 – successful.
Has anyone encountered before?ScenarioExchange environment is Exchange 2016 & Exchange 2019.Exchange 2016 – Extended Protection not enabledExchange 2019 – Extended Protection enabled.User mailbox is residing in Exchange 2019 User attempt to login via OWA (FBA) on Exchange 2016 When login, the page keeps looping back to the logon screen.Error in httproxy owa logs: WebExceptionStatus=ProtocolError;ResponseStatusCode=401;WebException=System.Net.WebException: The remote server returned an error: (401) Unauthorized. Attempted to login to both OWA & ECP via OWA on Exchange 2019 – successful. Read More
Using the Rules exception “is on a recipient’s supervision list”
In our tenant, I want to quarantine all inbound mail from gmail.com except for approved senders. Currently I do this with a Rule with an Exception:
Except if | The sender | is this person
Users send me exception email addresses that I manually enter.
I notice that there is another option for The Sender called “is on a recipient’s supervision list” I don’t fully understand the Microsoft documentation on this option. It says: Messages where the sender is on the recipient’s Allowlist or Blocklist. Does this mean each user can enter the desired exception email address(es) into their Outlook (desktop client) Allow / Block lists?
Any help to clarify is greatly appreciated.
In our tenant, I want to quarantine all inbound mail from gmail.com except for approved senders. Currently I do this with a Rule with an Exception:Except if | The sender | is this person Users send me exception email addresses that I manually enter.I notice that there is another option for The Sender called “is on a recipient’s supervision list” I don’t fully understand the Microsoft documentation on this option. It says: Messages where the sender is on the recipient’s Allowlist or Blocklist. Does this mean each user can enter the desired exception email address(es) into their Outlook (desktop client) Allow / Block lists?Any help to clarify is greatly appreciated. Read More
When checkbox selected, enter specific value into spreadsheet
Greetings,
I have a userform that contains multiple checkboxes that, when checked, I would like to enter “Y” or “N” into a spreadsheet. I’m getting an error when I use an IF statement on line 18 below and am not sure why.
Any assistance would be appreciated as I have numerous checkboxes on various forms that will obviously cause an issue moving forward.
Thanks!
With Sheets(“TIER ACCESS”)
‘copy and pasted into “Sheet2” on the last row without text.
lr = .Range(“A” & Rows.Count).End(3).Row + 1
.Range(“A” & lr).Value = FirstName.Value & ” ” & LastName.Value ‘ USER NAME
.Range(“B” & lr).Value = OPSEmail.Value ‘ PASSWORD
.Range(“C” & lr).Value = OPSEmail.Value ‘ EMAIL ADDRESS
.Range(“D” & lr).Value = Date & ” ” & Time ‘ DATE USER ADDED
.Range(“E” & lr).Value = Sheets(“HOME PAGE”).Range(“M3”).Value ‘ USER ADDED BY
.Range(“F” & lr).Value = “Yes” ‘ ACTIVE USER
.Range(“G” & lr).Value = “TIER 1” ‘ USER TIER
.Range(“H” & lr).Value = “PURGE, ADD, MODIFY” ‘ CLIENT PROFILE PERMISSIONS
.Range(“I” & lr).Value = “NO PERMISSIONS” ‘ NON-CLIENT PROFILE PERMISSIONS
.Range(“J” & lr).Value = “N” ‘ UserAccess
.Range(“K” & lr).Value = “N” ‘ TIER ACCESS WS
.Range(“L” & lr).Value = “N” ‘ LIST WS
.Range(“M” & lr).Value = “N” ‘ CLIENTS WS
.Range(“N” & lr).Value = “Y” ‘ CLIENT PROFILES WS
.Range(“O” & lr).Value = if DTTCheckBox.Value = true then “Y” ‘ DTT WS
.Range(“P” & lr).Value = “Y” ‘ TECHNOLOGY WS
.Range(“Q” & lr).Value = “Y” ‘ UNIFORM WS
.Range(“R” & lr).Value = “Y” ‘ LiDAR & RADAR WS
.Range(“S” & lr).Value = “Y” ‘ VEHICLES WS
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
Greetings, I have a userform that contains multiple checkboxes that, when checked, I would like to enter “Y” or “N” into a spreadsheet. I’m getting an error when I use an IF statement on line 18 below and am not sure why. Any assistance would be appreciated as I have numerous checkboxes on various forms that will obviously cause an issue moving forward. Thanks! With Sheets(“TIER ACCESS”)
‘copy and pasted into “Sheet2” on the last row without text.
lr = .Range(“A” & Rows.Count).End(3).Row + 1
.Range(“A” & lr).Value = FirstName.Value & ” ” & LastName.Value ‘ USER NAME
.Range(“B” & lr).Value = OPSEmail.Value ‘ PASSWORD
.Range(“C” & lr).Value = OPSEmail.Value ‘ EMAIL ADDRESS
.Range(“D” & lr).Value = Date & ” ” & Time ‘ DATE USER ADDED
.Range(“E” & lr).Value = Sheets(“HOME PAGE”).Range(“M3”).Value ‘ USER ADDED BY
.Range(“F” & lr).Value = “Yes” ‘ ACTIVE USER
.Range(“G” & lr).Value = “TIER 1” ‘ USER TIER
.Range(“H” & lr).Value = “PURGE, ADD, MODIFY” ‘ CLIENT PROFILE PERMISSIONS
.Range(“I” & lr).Value = “NO PERMISSIONS” ‘ NON-CLIENT PROFILE PERMISSIONS
.Range(“J” & lr).Value = “N” ‘ UserAccess
.Range(“K” & lr).Value = “N” ‘ TIER ACCESS WS
.Range(“L” & lr).Value = “N” ‘ LIST WS
.Range(“M” & lr).Value = “N” ‘ CLIENTS WS
.Range(“N” & lr).Value = “Y” ‘ CLIENT PROFILES WS
.Range(“O” & lr).Value = if DTTCheckBox.Value = true then “Y” ‘ DTT WS
.Range(“P” & lr).Value = “Y” ‘ TECHNOLOGY WS
.Range(“Q” & lr).Value = “Y” ‘ UNIFORM WS
.Range(“R” & lr).Value = “Y” ‘ LiDAR & RADAR WS
.Range(“S” & lr).Value = “Y” ‘ VEHICLES WS
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “”
‘ .Range(“” & lr).Value = “” Read More
why wont the formula =countif(f:f,f3)=1 not prevent a duplicate value
why wont the formula =countif(f:f,f3)=1 not prevent a duplicate value
why wont the formula =countif(f:f,f3)=1 not prevent a duplicate value Read More
How to capture replies to a bot’s message in a Microsoft Teams Channel without mentioning the bot?
I have developed a message extension bot app for Microsoft Teams and I want to capture replies to a message posted by the bot in a Teams channel without requiring users to mention the bot directly.
I am using Node.js and TypeScript for my bot.
The bot is registered in the Azure Bot Service.
I want to capture replies to this message without users needing to mention the bot. How can I achieve this?
Any guidance or examples would be greatly appreciated!
I have developed a message extension bot app for Microsoft Teams and I want to capture replies to a message posted by the bot in a Teams channel without requiring users to mention the bot directly.I am using Node.js and TypeScript for my bot.The bot is registered in the Azure Bot Service.I want to capture replies to this message without users needing to mention the bot. How can I achieve this?Any guidance or examples would be greatly appreciated! Read More
1449/1.0.94.202407110 update has removed transfer to Voicemail
Teams Devices version 1449/1.0.94.202407110. Desk phones no longer have the option to transfer calls directly to Work Voicemail after the person is selected. It was replaced by Call Teams, which is the same as Call Work Number.
I am baffled at the removal of such a critical function of a phone system. Receptionist efficiency is severely degraded with the removal of the function.
Teams Devices version 1449/1.0.94.202407110. Desk phones no longer have the option to transfer calls directly to Work Voicemail after the person is selected. It was replaced by Call Teams, which is the same as Call Work Number.I am baffled at the removal of such a critical function of a phone system. Receptionist efficiency is severely degraded with the removal of the function. Read More
Crowdstrike Agent with Microsoft Purview DLP
Could we use CrowdStrike as the main (Active) EDR while also enrolling the same machine into the agent-based Purview DLP? We have currently deployed MDE (passive) through the MDE Portal Onboarding, with RTP (Real-Time Protection) and BM (Behavioral Monitoring) enabled in the policy settings.
While testing policies against user devices, we are unable to generate any alerts that match a rule based on conditions (e.g. PII, CC Data – where a user tries to copy and print sensitive information in a document), and the action based on the rule should be to BLOCK. This is not happening because there seems to be a disconnect from the workstation receiving the policies from Purview.
Could we use CrowdStrike as the main (Active) EDR while also enrolling the same machine into the agent-based Purview DLP? We have currently deployed MDE (passive) through the MDE Portal Onboarding, with RTP (Real-Time Protection) and BM (Behavioral Monitoring) enabled in the policy settings.While testing policies against user devices, we are unable to generate any alerts that match a rule based on conditions (e.g. PII, CC Data – where a user tries to copy and print sensitive information in a document), and the action based on the rule should be to BLOCK. This is not happening because there seems to be a disconnect from the workstation receiving the policies from Purview. Read More
Drawdown Schedule W/Timeline
Hello – I’m attempting to build an excel based timeline schedule with a budget drawdown based on individuals and amounts. Would there be any examples or is excel capable for such a task? Open to suggestions. Thanks in advance.
Hello – I’m attempting to build an excel based timeline schedule with a budget drawdown based on individuals and amounts. Would there be any examples or is excel capable for such a task? Open to suggestions. Thanks in advance. Read More
