Results 1 to 10 of 935

Thread: Windows 10 and Office Excel

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #11
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10
    From April 2022
    This is post
    https://excelfox.com/forum/showthrea...e-Excel/page52
    https://excelfox.com/forum/showthrea...ge52#post12786
    https://excelfox.com/forum/showthread.php/2408-Windows-10-and-Office-Excel/page52#post12786




    Its early April, 2022, and I am thinking about going outside for the summer to finish building my Bavarian castle. So I will tidy up my Debloat windows 10 script stuff, and forget about untill next winter

    Review where am I.
    In February/March 2022, I had to some repair work after strong storms, and watched a lot of videos learning PowerShell script.
    Chris did some updates on his Debloat script, and I finally found out how to get scripts from the time to match older videos. So I did a few more posts in the last two pages,
    _ Page 50, from https://excelfox.com/forum/showthrea...ge50#post12774 to get my script updated to Chris’s latest
    _ Page 51, from https://excelfox.com/forum/showthrea...ge51#post12780 to go again through the main Debloat videos with the benefit of having the actual scripts to which the videos were referring

    So I am was up to my version Temp6.ps1 , and my GUI looked something like this:


    _......So , moving on quickly, so I can switch the computer off until next winter

    _.____________________________

    Start with the GUI (size)
    I will take a finger in the wind guess, or estimate, a guestimate, based on all in my head, to try and start with approximately of what the final GUI should be like.
    An Idea might be to have it have things in it making it very wide, possible deep also, but to make effective use of the scroll bars, for example to “hide” things that should possibly not be used too recklessly, or things I am not so interested in currently.
    I will need to make the actual given size smaller. – That is just how it seems to work – set a smaller size than needed to hold all panes and other things you put in it.

    The height will be some average of all issues come across so far, something like, 600.
    I will start with about '800, 600' ( width , height )

    GUI better formatting, colours?
    I think I may have been a bit mislead by some Blogs and YouTube videos into thinking that the simple PowerShell script GUI is boring. Not true. PowerShell, unlike the simpler Shell cmd black window stuff, is somehow linked into the same Object orientated program stuff that Visual Basic is.
    I had an little initial fiddle with colours, and made a few other minor updates, and fiddles, taking my version to Temp7.ps1 , https://app.box.com/s/fttlmwny6y4s5ub1q66kvqbrw2ppxdwz
    jdklad

    Resizable GUI window and Scroll bar.
    A working scroll bar is no problem – one code line. A GUI is resizable as standard default.
    Just one subtlety , as mentioned before: If you want a scroll bar to always be there, as I do, you need to place things outside the window size. The script will not error if you do that. The things outside your given window size will need to be got by scrolling. Hence the scroll bar is there from the start.
    (If you had all things placed and dimensioned inside your main given GUI size window, then the scroll bars do mot apper at first. They will appear if needed, if you reduce the size ( by dragging right or bottom perimeters ) such that things no longer fit in.
    A convenient way to achieve what I want is to simply dimension Panels larger than the given GUI window size ( Panels are crudely similar to like GUI Windows inside, and fixed in, the GUI )

    So I have my Panels conveniently set to such a size such that they are like columns deeper than the set main GUI window size.
    For forcing the wider width, simple long comments or extended headings will do, as that is something I like generally in coding. Or alternatively stuff I might be experimenting with and/ or not sure I want to keep it there finally


    Results
    https://i.postimg.cc/ZKy0hPKC/Scroll...in-for-now.jpg
    https://i.postimg.cc/sfL18Hzk/Scroll...-red-stuff.jpg









    The next posts I do things in the next 6 Months a bit ad hoc, a few random things, progressing slowly when I feel like it..

    I might be a bit extravagant going up in version numbers. There might not be many changes from one version to the other, but text storage is very easy and cheap, and it’s a simple alternative to a GitHub version control catastrophe, in seeing where changes might have introduced problems!
    ( Thank god they banned me from GitHub, - I might otherwise of wasted my life trying to figure the place out. In the meantime Microsoft would have infiltrated it, if they haven’t already, and would be running the rest of my life, Lol ))











    Temp6.ps1 – Black and White - https://app.box.com/s/sn8dsqt237zffgkmjaqnvn7ewvqjdou8
    Temp8.ps1 - Colour - https://app.box.com/s/9b9li86s7dyysr7exdle30pckgp7vscz
    Last edited by DocAElstein; 04-02-2022 at 11:19 PM.

Similar Threads

  1. Replies: 51
    Last Post: Yesterday, 09:29 PM
  2. Tests and Notes on Range Referrencing
    By DocAElstein in forum Test Area
    Replies: 70
    Last Post: 02-20-2024, 01:54 AM
  3. Tests and Notes for EMail Threads
    By DocAElstein in forum Test Area
    Replies: 29
    Last Post: 11-15-2022, 04:39 PM
  4. Notes tests. Excel VBA Folder File Search
    By DocAElstein in forum Test Area
    Replies: 39
    Last Post: 03-20-2018, 04:09 PM
  5. Replies: 2
    Last Post: 12-04-2012, 02:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •