Excel can be fun and contagious. CD Drive Open and Close....if it is still there
Excel can be fun and contagious. So that some may remember the old days and some may have fun playing with it today Excel doesn't always have to be serious, it can also be funny 🙂 Have fun everyone, enjoy the time. Wish everyone a nice day or night with a lot of health, joy and love. Nikolino I always know that I don't know anythingcreate a kind of Gantt beam from a Working time sheet
Hello people need help too, Would like to create a kind of Gantt beam in this worksheet. Would like to enter the working hours (von=from, bis=to) in sheet "January", in three Duties ( Dienst1, Dienst2, Bereitschaft ) and in MA1 to 9 (colleagues) as well as the TeamChief, in the end it should be in the specified beam in sheet "IND1" should appear. The bar / timeline should appear (“IND1”) in the default color and row of the colleague I insert the working time in sheet “Januar”. Only the entered working hours should appear with color in sheet “IND1”, everything else without color in the row. In the end, the VBA code should be so that I simply copy it into the next sheet every month. A very nice person wrote me this VBA code (which I am also very grateful for) to accomplish my project. However, due to my VBA ignorance, I overexcited his good mood. I tried all the days to make it on my own, but without success. That’s why I contact the community. Any help in any kind is welcome and would like to thank you in advance for taking the time to read my request. If it could come to a solution, I would not only be happy, but also to do a somersault ... and that at my age :-))VBA - Show data selection in pop-up menu
Hi Guys, have a "little" problem where I need a little help. I have a user form with a list field where I take data from a table from another worksheet. My problem is that it only shows the labeling area and not the data. VBA Code in Scheet1 Option Explicit Private Sub Worksheet_BeforeRightClick(ByVal Target As Excel.Range, Cancel As Boolean) Me.Unprotect ("1234") If Not Intersect(Target, Range("G5:EZ6")) Is Nothing Then Cancel = True ASK_Auswahl.Show End If Me.Protect ("1234") End Sub User Form in sheet 1 Sheet2 - table where the data is taken from Properties window in lists Box1 How can I get all data from Sheet2 to be displayed in the user form? Thx in Advance 🙂 Nikolinoincorrect formulation
Hello everyone, need a little food for thought ... or better...need your help 🙂 Examble (Cell L14) : =ODER(UND(L$9>=$C$3;L$9<=$D$3);UND(L$9>=$E$3;L$9<=$F$3); UND(L$9>=$G$3;L$9<=$H$3)) With this formula I can create a timeline as long as the working time is longer. If the working hours from 8:00 p.m. to 11:00 p.m. then everything is ok, shows how it should display. If the working hours are from 10pm to 3am then it shows empty, how can I correct this error in my formula? Nikolino I know I don't know anything (Socrates)Excel Community: Simplifying Spaces and Labels
Hi all, As you may have noticed already, we as the Excel Team have done a bit of "spring/summer cleaning" for the community. We have received feedback that the number of "spaces" was simply too many at nine, so we have pared things down. Now, there are three community spaces: Excel: this will be the primary place for posting content, as many of the old spaces have been migrated as labels will find a good home here BI and Data Analysis: this will be a good place for posting about tasks and questions that cut across Excel, Power BI, and other topics in this realm Resources and Community: this will increasingly become a place for folks to share sample files and templates with each other Q: What happened to the other spaces that used to exist? A: They have since been rolled up as "Labels", which you can find in the "More Resources" sidebar under "Labels" of any of the three spaces mentioned above. Look for these on the right side: Please let us know if you have any other questions. Thanks for reading!
Copied a Macro-Enabled Workbook into OneDrive, now macros cannot be run, edited, or deleted.
I have a Macro-Enabled Workbook that I've been using for over a year with no issues in using the macros inside. Yesterday I copied this workbook into my OneDrive folder. Now, when I open the file from the local copy on my hard drive, I cannot run, edit, or delete any macros. I can record a new macro, but that macro has the same limitations as previously created macros, it cannot be run, edited, or deleted. Trying to run a macro produces this error message: That sounds like a lead, except that when I open the workbook I do not get a security banner at all, though the banner settings are enabled. I have tried these settings in the Trust Center and they have not altered the behavior of macros. I added the local hard drive location for OneDrive to Trusted Locations, including checking the box to include all subfolders, but this has not fixed the issue. I should not have to use the un-secure macro security settings I posted above, but I would make do if they actually worked. As it is, I am stumped on how to fix this issue. I would really love to be able to use OneDrive for my important documents, but most of my important Excel Workbooks have at least one macro in them, since I use them to save time on tasks that are repeated often. Update 4/4/2022 I've done some more testing and it is definitely an issue related to the Trusted Locations in Office. I created a new folder and added that folder to Trusted Locations. I was able to use macros from files in that folder without any issues. Then I uninstalled and re-installed OneDrive and pointed it to that folder for its base location. After OneDrive took over the folder, macros no longer worked from files in that folder. Basically, Office is not recognizing a OneDrive folder as a Trusted Location despite the folder being in the list. If it helps, here are my Office and OneDrive versions: Office - Version 2203 (Build 15028.20160 Click-to-Run) Current Channel OneDrive - Version 2022 (Build 22.033.0213.0002) Update 4/18/2022 I ran a test with Dropbox, since it's a similar service. I am able to get the local Dropbox folder recognized properly as a Trusted Location in Office and macros work fine once that's done. Which means it's not automatic just because an app is monitoring the folder for synchronization. So, this seems to be purely a question of how to fix OneDrive to make it work correctly with Trusted Locations.Would a FOR.EACH function be useful in Excel 365?
The attached files are based upon a workbook that emulates the proposed function using a VBA macro. There would appear to be many potential applications in situations where the @operator needs to be used to restrict the operation of an array parameter.
