Category: Microsoft
Category Archives: Microsoft
Hide/unhide rows using a button
Hello everyone.
I am trying to configure a button to hide/unhide several rows at a time.
I am following these steps:
1) Adding a toggle button in the Active X control
2) Then I double click in the button, and paste the following code:
Private Sub ToggleButton1_Click()
Dim xAddress As String
Dim splitAddress As Variant
xAddress = “4:7”
splitAddress = Split(xAddress, “,”)
If ToggleButton1.Value Then
For Each Var In splitAddress
Application.ActiveSheet.Rows(Var).Hidden = True
ToggleButton1.Caption = “+”
Next Var
Else
For Each Var In splitAddress
Application.ActiveSheet.Rows(Var).Hidden = False
ToggleButton1.Caption = “-“
Next Var
End If
End Sub
3) I insert a new button following the same procedure, double click it and add code for the new button, with a different set of rows. Now it looks like this:
Private Sub ToggleButton1_Click()
Dim xAddress As String
Dim splitAddress As Variant
xAddress = “4:7”
splitAddress = Split(xAddress, “,”)
If ToggleButton1.Value Then
For Each Var In splitAddress
Application.ActiveSheet.Rows(Var).Hidden = True
ToggleButton1.Caption = “+”
Next Var
Else
For Each Var In splitAddress
Application.ActiveSheet.Rows(Var).Hidden = False
ToggleButton1.Caption = “-“
Next Var
End If
End Sub
Private Sub ToggleButton2_Click()
Dim xAddress As String
Dim splitAddress As Variant
xAddress = “9:14”
splitAddress = Split(xAddress, “,”)
If ToggleButton1.Value Then
For Each Var In splitAddress
Application.ActiveSheet.Rows(Var).Hidden = True
ToggleButton1.Caption = “+”
Next Var
Else
For Each Var In splitAddress
Application.ActiveSheet.Rows(Var).Hidden = False
ToggleButton1.Caption = “-“
Next Var
End If
End Sub
The first toggle button is working fine, but the second is not, even when is the same code.
What am I doing wrong here?
Thanks.
Hello everyone. I am trying to configure a button to hide/unhide several rows at a time.I am following these steps: 1) Adding a toggle button in the Active X control 2) Then I double click in the button, and paste the following code: Private Sub ToggleButton1_Click()
Dim xAddress As String
Dim splitAddress As Variant
xAddress = “4:7”
splitAddress = Split(xAddress, “,”)
If ToggleButton1.Value Then
For Each Var In splitAddress
Application.ActiveSheet.Rows(Var).Hidden = True
ToggleButton1.Caption = “+”
Next Var
Else
For Each Var In splitAddress
Application.ActiveSheet.Rows(Var).Hidden = False
ToggleButton1.Caption = “-“
Next Var
End If
End Sub 3) I insert a new button following the same procedure, double click it and add code for the new button, with a different set of rows. Now it looks like this: Private Sub ToggleButton1_Click()
Dim xAddress As String
Dim splitAddress As Variant
xAddress = “4:7”
splitAddress = Split(xAddress, “,”)
If ToggleButton1.Value Then
For Each Var In splitAddress
Application.ActiveSheet.Rows(Var).Hidden = True
ToggleButton1.Caption = “+”
Next Var
Else
For Each Var In splitAddress
Application.ActiveSheet.Rows(Var).Hidden = False
ToggleButton1.Caption = “-“
Next Var
End If
End Sub
Private Sub ToggleButton2_Click()
Dim xAddress As String
Dim splitAddress As Variant
xAddress = “9:14”
splitAddress = Split(xAddress, “,”)
If ToggleButton1.Value Then
For Each Var In splitAddress
Application.ActiveSheet.Rows(Var).Hidden = True
ToggleButton1.Caption = “+”
Next Var
Else
For Each Var In splitAddress
Application.ActiveSheet.Rows(Var).Hidden = False
ToggleButton1.Caption = “-“
Next Var
End If
End Sub The first toggle button is working fine, but the second is not, even when is the same code.What am I doing wrong here?Thanks. Read More
Notifications when someone joins a Meeting
Hi!
Is there any option to enable notification if someone joins a Meeting not using dial-in numbers, just regular meetings on the windows app?
I followed this documentation https://learn.microsoft.com/en-us/microsoftteams/turn-on-or-off-entry-and-exit-announcements-for-meetings-in-teams but I could not find the Conference Bridges option on the admin pannel.
Is there any place where I can request for this feature?
Thanks in advance! 😀
Hi! Is there any option to enable notification if someone joins a Meeting not using dial-in numbers, just regular meetings on the windows app? I followed this documentation https://learn.microsoft.com/en-us/microsoftteams/turn-on-or-off-entry-and-exit-announcements-for-meetings-in-teams but I could not find the Conference Bridges option on the admin pannel. Is there any place where I can request for this feature? Thanks in advance! 😀 Read More
Exchange Online’s New High Volume Email (HVE) Solution
The Exchange Online High-Volume Email (HVE) solution handles up to 100,000 internal messages and 2,000 external messages daily. It’s intended to replace on-premises Exchange servers that organizations keep just to service email submission from devices and applications. In this review of the preview version, we discovered that almost everything works just fine, if you keep within the throttling limits.
https://practical365.com/exchange-online-hve/
The Exchange Online High-Volume Email (HVE) solution handles up to 100,000 internal messages and 2,000 external messages daily. It’s intended to replace on-premises Exchange servers that organizations keep just to service email submission from devices and applications. In this review of the preview version, we discovered that almost everything works just fine, if you keep within the throttling limits.
https://practical365.com/exchange-online-hve/ Read More
How to save a prompt in Teams?
Is it possible to save prompts in Copilot Chat in Teams? Doc says “Select the Save prompt button on the prompt to save it”. But there is no such button (neither permanent no if hover over it) available for me.
Is it possible to save prompts in Copilot Chat in Teams? Doc says “Select the Save prompt button on the prompt to save it”. But there is no such button (neither permanent no if hover over it) available for me. Read More
MDI Sensors bandwith usage
Good morning, is it possible to understand or estimate the bandwidth usage of sensors in an environment with around 30 domain controllers and 10,000 users?
Is there any documentation regards this topic?
Thanks a lot
Good morning, is it possible to understand or estimate the bandwidth usage of sensors in an environment with around 30 domain controllers and 10,000 users?Is there any documentation regards this topic? Thanks a lot Read More
Forms – Polls in teams
Hi,
I used to prepare Forms questions and polls and launch theim during teams meeting.
As Forms is not working anymore in teams, how can I do the same thing with the new app “Polls” (preparing questions and launching theim at the right time) ?
Hi, I used to prepare Forms questions and polls and launch theim during teams meeting. As Forms is not working anymore in teams, how can I do the same thing with the new app “Polls” (preparing questions and launching theim at the right time) ? Read More
“Bookings with me” does not show calender events
I’ve been experiencing issues with the “Bookings with me” feature over the past few weeks or months. Previously, it functioned correctly, only displaying time slots when I was available. However, it now respects my working hours but fails to indicate whether I’m already booked or not. Even when I schedule an event through the booking page, it gets added to my calendar, but the time slot remains available for further bookings.
In contrast, the public link to my calendar displays all events as expected.
I’ve tested this issue with a colleague’s booking page, and it worked without any problems. Does anyone have any suggestions on how to resolve this issue?
Greetings from Germany,
Thorsten
I’ve been experiencing issues with the “Bookings with me” feature over the past few weeks or months. Previously, it functioned correctly, only displaying time slots when I was available. However, it now respects my working hours but fails to indicate whether I’m already booked or not. Even when I schedule an event through the booking page, it gets added to my calendar, but the time slot remains available for further bookings.In contrast, the public link to my calendar displays all events as expected.I’ve tested this issue with a colleague’s booking page, and it worked without any problems. Does anyone have any suggestions on how to resolve this issue? Greetings from Germany,Thorsten Read More
Microsoft to Charge for Unlicensed OneDrive for Business Accounts
Microsoft plans to archive unlicensed OneDrive sites starting in January 2025. The obsolete sites will end up in Microsoft 365 archive, from where the sites can be reactivated for a small per-gigabyte fee. Archived sites are indexed and discoverable. However, the message is clear: remove unlicensed OneDrive sites now. They’re only cluttering up your digital landscape and might give Copilot for Microsoft 365 a headache.
https://office365itpros.com/2024/07/30/unlicensed-onedrive-sites-archive/
Microsoft plans to archive unlicensed OneDrive sites starting in January 2025. The obsolete sites will end up in Microsoft 365 archive, from where the sites can be reactivated for a small per-gigabyte fee. Archived sites are indexed and discoverable. However, the message is clear: remove unlicensed OneDrive sites now. They’re only cluttering up your digital landscape and might give Copilot for Microsoft 365 a headache.
https://office365itpros.com/2024/07/30/unlicensed-onedrive-sites-archive/ Read More
Moving from FOCUS 1.0 preview to FOCUS 1.0
If you haven’t heard about the FinOps Open Cost and Usage Specification (FOCUS), check out our FOCUS 1.0 introduction blog post. But if you’re here, I’m guessing you’ve at least looked into the FOCUS 1.0 preview which we announced in November 2023. We were diligently working alongside the FOCUS community to implement feedback and solidify the general availability release of the specification, which we were excited to finally release at FinOps X this year. But you probably know all that by now, so let’s focus on the core changes you’ll find if you’re already using FOCUS 1.0 preview:
Resource region
Usage amounts
Contracted (on-demand) cost
Charge categorization
Dataset metadata
Resource region
In FOCUS 1.0 preview, we had a Region column to indicate what region resources were deployed to. The specification wasn’t clear as to whether this was the ID or name and, after discussion, it was determined that both are valuable for FinOps practitioners. With that, Region was renamed and split into separate RegionId and RegionName columns. In Azure, this will return lowercase values without spaces, like “brazilsouth” for the ID, and English display names, like “Brazil South”, for the name. For anyone new to our FOCUS dataset, it’s also important to note that FOCUS leverages the standard Azure region ID and display names, which are slightly different than the actual and amortized datasets. As an example, you’ll see “Brazil South” instead of “BR South”.
Related to the resource region, FOCUS 1.0 has declared that some columns, like AvailabilityZone are optional, and when not specified, they should not be included in the dataset. With that, we’ve removed the empty AvailabilityZone column from the FOCUS 1.0 dataset. Per the specification, we’ll re-add this column when we can include the value.
Usage amount
In FOCUS, the amount you’ve used or purchased is tracked with the PricingQuantity, which is coupled with the PricingUnit to explain what the quantity refers to. Some services are priced in “blocks”, like per 1,000 tokens for Azure OpenAI Service. Due to this, PricingQuantity is tracked separately from what was called UsageQuantity, which specified the distinct units without “blocking”. In FOCUS 1.0, UsageQuantity and UsageUnit were renamed to ConsumedQuantity and ConsumedUnit and changed to only represent usage amounts and explicitly not cover purchase amounts. This means, ConsumedQuantity will only have a value when ChargeCategory == “Usage”. To determine the amount purchased, please use the PricingQuantity.
Contracted (on-demand) cost
FOCUS 1.0 preview didn’t define a way to indicate what the on-demand unit price or cost was for a service after negotiated discounts were applied, but without commitment discounts. Given how important it is to calculate savings, we added extended columns for x_OnDemandCost and x_OnDemandUnitPrice to include this important detail. After much deliberation, FOCUS 1.0 introduced standard ContractedCost and ContractedUnitPrice columns for the same purpose. With that, we’ve renamed x_OnDemandCost and x_OnDemandUnitPrice columns to ContractedCost and ContractedUnitPrice.
Charge categorization
The biggest change in FOCUS 1.0 was a reclassification of the ChargeSubcategory column from 1.0 preview. ChargeSubcategory was used to indicate what type of usage or adjustment the charge (row) represents. Specifically, this indicated whether a charge related to a commitment discount was used or unused and whether an adjustment was a credit, refund, etc. In FOCUS 1.0, ChargeSubcategory was removed in favor of the following changes:
Refunds are now identified by ChargeClass == “Correction”.
ChargeCategory will be “Usage”, “Purchase”, etc. for any “correction” charges, allowing you to sum the total usage costs, including refunds.
Credits are now identified by ChargeCategory == “Credit” in FOCUS, but note that credits are not currently included in Cost Management data.
To determine whether a charge represents a used or unused portion of a commitment discount, use CommitmentDiscountStatus == “Used” or “Unused”.
Slightly tangential to these, PricingCategory values were also updated from “On-Demand” and “Commitment-Based” to “Standard” and “Committed”. The purpose and intent remains the same for these. Only the values changed.
Other updates
Beyond these core changes to the specification, we also updated the mappings used for regions, pricing units, service categories, and resource types to address a few gaps. These mapping files are hosted in the FinOps toolkit and available for anyone interested in data cleansing and normalization outside of FOCUS, like for historical datasets. If you notice anything missing, please do create an issue or submit a PR. To learn more, see the FinOps toolkit contribution guide.
Lastly, we also removed the empty x_ChargeId column. This column was discussed for inclusion, but didn’t ultimately make it into the specification, so we never implemented it. If you’d like to see this added as an official column, please do submit feedback to the FOCUS community, which I’ll cover in a bit.
Dataset metadata
Given FOCUS how supports a set of conditional columns which may not always be present, depending on what’s supported by the provider, it’s more important than ever to have a clear understanding of what columns are provided in the dataset, what data type they are, etc. This includes extended columns in addition to the FOCUS columns. To support this, we’ve added 2 new metadata files for FOCUS 1.0 and 1.0 preview in the FinOps toolkit.
We’d love to get your feedback on these to understand how you’ll use them. We’ve already identified a use within FinOps hubs as part of our data ingestion pipeline. Let us know how you use it and if there’s anything else you’d like to see. We’re considering expanding this to document data transformation steps to convert actual and amortized data to FOCUS and also providing these metadata files for non-FOCUS datasets to provide the same programmatic level of detail for data integration scenarios.
What’s next
So, what’s next for FOCUS? The main thing we (as the FOCUS community) are looking for is your feedback. Learn about FOCUS, leverage reusable FOCUS reports (like the Power BI reports in the FinOps toolkit), align your existing reporting to FOCUS, educate stakeholders, and most importantly, if you have questions or feedback about the columns or values you see in your FOCUS dataset, let us know!
If you have questions about the Microsoft implementation, feel free to ask here on Tech Community, contact the Cost Management team through your Microsoft Services account team, or ask in the #microsoft-cloud channel in the FinOps Foundation Slack community.
If you have questions or feedback about the specification itself, use the #chat-focus channel in the FinOps Foundation Slack community or create an issue in the FOCUS GitHub repository, which will be triaged by maintainers within a few days to determine if it should be added to the 1.1 release, which is coming in November 2024 at FinOps X Europe!
These are exciting times! It’s amazing to see 4 of the biggest cloud providers all adopting this revolutionary new data format! Let us know what you’d like to see as we plot out the future direction of FOCUS and our tooling to support your FinOps efforts.
Microsoft Tech Community – Latest Blogs –Read More
Freezing panels – other users worksheet
Hi,
We are working on worksheet ( few users using the same worksheet ), and whenever one of the users uses freezing panels option in view menu it happens for all the users currently working on worksheet.
Is there a way or addin that will allow implementation of freeze panels only for that one specific user ?
Hi,We are working on worksheet ( few users using the same worksheet ), and whenever one of the users uses freezing panels option in view menu it happens for all the users currently working on worksheet. Is there a way or addin that will allow implementation of freeze panels only for that one specific user ? Read More
Is there a way to get Copilot to look through a PDF file in a public website and summarise it?
Is it possible for Copilot to look through a file in a public website and retrieve information from it? For example, when I asked Copilot to
“extract Volkswagen AG’s latest inventory balance for the quarter ended March 2024, as per the investor relations section on their website.”
I received this answer
“I’m sorry, but I don’t have the capability to extract specific financial data from external websites such as Volkswagen AG’s investor relations section. However, you can usually find this information by visiting the investor relations page of Volkswagen AG’s website and looking for their financial reports or quarterly statements. These documents typically include detailed information about the company’s inventory balance and other financial metrics for the quarter. If you need assistance with analyzing the data or have any other questions, feel free to ask!2”
I downloaded the file and tried to attach it to the chat but Copilot complained about the file size (20MB)
Am I doing something wrong or are these actually Copilot limitations?
Many thanks!
Zainab
Is it possible for Copilot to look through a file in a public website and retrieve information from it? For example, when I asked Copilot to “extract Volkswagen AG’s latest inventory balance for the quarter ended March 2024, as per the investor relations section on their website.” I received this answer “I’m sorry, but I don’t have the capability to extract specific financial data from external websites such as Volkswagen AG’s investor relations section. However, you can usually find this information by visiting the investor relations page of Volkswagen AG’s website and looking for their financial reports or quarterly statements. These documents typically include detailed information about the company’s inventory balance and other financial metrics for the quarter. If you need assistance with analyzing the data or have any other questions, feel free to ask!2” I downloaded the file and tried to attach it to the chat but Copilot complained about the file size (20MB) Am I doing something wrong or are these actually Copilot limitations? Many thanks!Zainab Read More
Ghant Chart Times scale Dates
Please assist,
How do I change the time scale on the Ghant view.? I shows the year as 2025 July.. I need it to show Month first then year. The drop down also does not show the format I want only this????
Please assist, How do I change the time scale on the Ghant view.? I shows the year as 2025 July.. I need it to show Month first then year. The drop down also does not show the format I want only this???? Read More
How to recover deleted files from SD Card for free on Windows 10?
Hi everyone,
I have an SD card connected to my camera and I accidentally deleted dozens of photos from it. I’m using Windows 10 and I’m desperately looking for a way to recover deleted files from SD Card. These photos are really important to me, so I’m hoping there’s a reliable solution out there.
I’ve read that it’s possible to recover deleted files from an SD card as long as they haven’t been overwritten, but I’m not sure which tools or methods are the best to use. I would appreciate any recommendations for reliable and easy-to-use software that can help me recover my deleted photos.
Regards,
Hunter
Hi everyone, I have an SD card connected to my camera and I accidentally deleted dozens of photos from it. I’m using Windows 10 and I’m desperately looking for a way to recover deleted files from SD Card. These photos are really important to me, so I’m hoping there’s a reliable solution out there. I’ve read that it’s possible to recover deleted files from an SD card as long as they haven’t been overwritten, but I’m not sure which tools or methods are the best to use. I would appreciate any recommendations for reliable and easy-to-use software that can help me recover my deleted photos. Regards,Hunter Read More
KQL Query for Defender for Endpoint to Hunt Users who download any new software.
Hello Everyone,
Anyone could help me to build a KQL query in which I can hunt users who download any new software in my company environment. see below is a query which i build but this query results me all logs including system logs, I just want to see only new downloaded files software logs.
”
Hello Everyone, Anyone could help me to build a KQL query in which I can hunt users who download any new software in my company environment. see below is a query which i build but this query results me all logs including system logs, I just want to see only new downloaded files software logs.” // Define the time range for the querylet startTime = ago(7d);let endTime = now();// Filter DeviceFileEvents for downloaded executable files (e.g., .exe, .msi)DeviceFileEvents| where ActionType == “FileCreated”| where FileName endswith “.exe” or FileName endswith “.msi” or FileName endswith “.msix” or FileName endswith “.dmg”| summarize Count = count(), FirstSeen = min(Timestamp), LastSeen = max(Timestamp) by DeviceId, Timestamp, ReportId, DeviceName, InitiatingProcessAccountName, FileName, FolderPath| project DeviceId, Timestamp = LastSeen, ReportId, DeviceName, User = InitiatingProcessAccountName, FileName, FolderPath, Count, FirstSeen, LastSeen| order by LastSeen desc” Read More
Allow all external domain
Hi,
When i applied the policy i was unable to chat with other organization users can any one tell which configuration i have missed
Hi,When i applied the policy i was unable to chat with other organization users can any one tell which configuration i have missed Read More
Microsoft Outlook for iOS and Android: The Dictation feature will retire in September 2024
Hi everyone,
Got an email from Microsoft message centre saying the Dictation feature will be retired in Sept 2024 for iOS and Android devices.
However, according to the MC841218 Admins don’t have any option to override this. Any reasons why Microsoft will retire this feature, considering accessibility for end users will be affected?
Also, any advise in how to check, how many users use this feature?
Hi everyone, Got an email from Microsoft message centre saying the Dictation feature will be retired in Sept 2024 for iOS and Android devices.However, according to the MC841218 Admins don’t have any option to override this. Any reasons why Microsoft will retire this feature, considering accessibility for end users will be affected?Also, any advise in how to check, how many users use this feature? Read More
¿Cómo llamar al teléfono United México?::-
Para marcar al teléfono United Airlines México llame aquí +52 –55 8526 3538 / +52 -55 8526 3538 Atención al cliente de esta aerolínea está abierto 24*7 horas para ayudar a los clientes de United Airlines México. por teléfono puede hacer el cambio de vuelo. dejar abiertos los billetes, con los ejecutivos de aerolíneas United México. @pacos
Para marcar al teléfono United Airlines México llame aquí +52 -55 8526 3538 / +52 -55 8526 3538 Atención al cliente de esta aerolínea está abierto 24*7 horas para ayudar a los clientes de United Airlines México. por teléfono puede hacer el cambio de vuelo. dejar abiertos los billetes, con los ejecutivos de aerolíneas United México. @pacos Read More
Window defender Black Screen
Since last week, my Windows Defender hasn’t been working. In the Control Center, it says, ‘The Windows Security Center Service can’t be started.’ Additionally, when I open Windows Defender, it displays a blank or black screen. Please help me fix this.
Since last week, my Windows Defender hasn’t been working. In the Control Center, it says, ‘The Windows Security Center Service can’t be started.’ Additionally, when I open Windows Defender, it displays a blank or black screen. Please help me fix this. Read More
