Posts by Benjamin Wilson7

Maybe it’s just the difference between those old .doc files and the newer .docx format? You know, the one where the file size is actually significantly smaller?

Kyle Johnson2 said:It’s not quite going to work the way you’re picturing it.
Looks like you totally overlooked the SHIFT key.
......
You'll need to find another way to keep all the sheets hidden until the macro kicks in and unhides them.

I'll dig into this a bit more and maybe I'll add it to the tutorial later.

How was I supposed to see this coming when I didn't even know it was possible? 🤷
Now you've gone and put me in a real bind!😢

I mean, I get what Benjamin Wilson7 is getting at, but what’s actually the point? If you already have a template set up in Microsoft Excel and you're just planning to fill it out on your computer anyway, why bother? I don't quite follow the logic there.

Is it just me, or does this workflow make absolutely zero sense? You print out these blank forms, then you go back to your computer to fill in all those empty fields in a Microsoft Excel spreadsheet, only to try and print everything right back onto those same physical sheets... why? Am I missing something here, or is this just a total waste of time?

Worried about someone messing up your template? Just password-protect the file! It’s actually pretty simple and elegant: lock all the fields that shouldn't be touched and leave only the specific entry boxes unlocked for them to fill out. Why deal with the headache of broken formulas? The best part is you end up with a perfect archive of data for every single employee right there in one Microsoft Excel file—you can just call the whole thing "Unknown Organization All Employees." Easy, right?
You could always color the input fields green or something, right? Then, if you just set the page setup to black and white before printing, you're all set!

Do you have that tutorial from Kyle Johnson on YouTube? Check out this link! So, looking at chapters 36 and 37... we're talking about protecting cells and entire files, right? Or is there more to it? Hey.

Kyle Johnson2, your code from the tutorial under
Preventing access to Workbook after a certain date - setting an access password
is exactly what I was looking for. I dropped it into the VBA under VBE ThisWorkbook and it works like a charm! The file format is xlsm.

A slightly funny question:
Since I'm the one who built the program, if I use the code above with something like: deadline = DateSerial(2010, 5, 30) (a date in the past), how can I get back into the program to change that expiration date? (Unless I have a master template set for, say, 2030, and then make copies with shorter lifespans). I can't even open the test version anymore!

Other details:
1. Other users don't have permission to change the system date or time—only the admin does—so that shouldn't be an issue for me.
2. All 30 Sheets (which aren't "very hidden," though they are) are locked except for the input fields (unlocked). So, for this specific program, I don't need people typing in passwords for every single sheet (that would be such a pain!), and there's no risk involved. It’s enough for the Workbook to just close itself after a certain date; I still want to keep the code for individual sheets because I use them for other projects.
3. In the editor, you can't get to the modules or any other VBA stuff without the access code.
4. As far as hacking goes, I know Excel isn't exactly a high-security bank vault, but for this level of use, it’s more than sufficient.

Your TUT is amazing, truly top-tier work.
A huge THANK YOU.

Actually, I'll just change the system date. I'm smart enough for that. So, forget my silly question—I clearly had a momentary brain fart.

Kyle Johnson2, I just got back from my trip, and man, I am starving and exhausted—honestly, I can barely keep my eyes open! But I saw your post and had to swing by quickly to see what you wrote.
I’m going to sit down tomorrow afternoon and really dig into everything you mentioned.
You shared some incredibly kind things up there; some of it I already knew and actually use, but a few of those ideas and solutions? Totally new to me.
I'll take a much closer look tomorrow and then get back to you here.
All I can say for now is a massive thank you.
It’s pretty obvious now who Toni Milun is taking inspiration from (he's an awesome guy). 🙂

I’m looking to implement some VBA code—let's call it the "time lock code"—for a specific Excel file that several different people use.
The main file password is something like "AB," and it stays the same for everyone all year long.
Inside, there are about 30 Sheets that are also locked with two different passwords (some might be "CD," others "EF," for example), though the actual data entry fields on those Sheets remain unlocked.

I'm weighing a few different ways to handle this:
1. Once a user enters the password "AB", they still shouldn't be able to open the file after a specific date set in the VBA code. For instance, I could set it to the last day of the quarter—so for Q2, that would be June 30th—and then I'd just manually update it every quarter.
2. Or, maybe entering password AB opens the file, but it completely disables data entry in all the free fields across all Sheets.
3. Honestly, a notification pop-up isn't strictly necessary; otherwise, I'll just get a phone call complaining that they can't enter their data! 🙂

I'd appreciate any ideas you guys have.
p.s. I won't be available to check back here until tomorrow evening.

Kyle Johnson2 is posting just above yours. You should definitely check out his pages; for GRAF, he’s already laid everything out perfectly with great diagrams.

By the way, Yubito is an absolute lifesaver when you need to search how to do things in Excel.
If you aren't a total beginner, you'll find your way around easily enough.

Look, just try using some other software—maybe GOM, BS Player, Adobe Flash, or VLC... you’ve got plenty of options out there.
And please, don't start coming at me, because you're honestly mistaken here.

driftingpilot8 said:Hey there!

Quick question:
How do I get rid of all these leftover table remnants (basically just Word relics) in Excel? I just want the raw numbers and data, nothing else.
I copied some stuff over from Word, but it brought all those weird formatting leftovers along with it. What's the fastest way to scrub them out?

http://imageshack.us/photo/my-images...znaslovai.png/

Maybe try using "Find & Select" -> Go To Special -> check the box for Objects
and then just hit delete.

Chloe Murphy66 said:Help me out here,
I was building a Pivot Table, and I accidentally selected an entire column for one of my VLOOKUP columns that pulls from another worksheet. Now, in my main sheet where that VLOOKUP lives, everything after my actual data all the way down to the bottom is just showing #N/A errors. It’s making my file absolutely massive! How can I stop it from selecting the whole damn column?
Maybe this is a silly question, but I'm honestly stuck. 🙂

If you go under Options and click on your Pivot Table, just head over to "Change Data Source"—that's where you define the size of the Pivot Table, if I'm reading the situation right.
In that box, under the table range, it probably says something like "Sheet1!$A:$F". You should either type in the specific row number after the column letter (like $A$1:$F$500) or just use your mouse to highlight the actual data range in Sheet1 and let it auto-fill the range for you.

Is there a specific formula I can use in Excel to actually plot a graph that looks like a blonde woman on a coordinate system? Thanks a million in advance!
Just wanted to drop in and say hi to the awesome crew—Nicholas King, Walter Jackson48, and Kyle Johnson2.

Honestly, this movie is just a total mess.
p.s. I am not Sarin's husband.🙂

bluecyclist64 said:So, here’s the deal:
whenever I'm working in Word, I'll hit Ctrl+S every so often to save my progress.
But a few times now, instead of just saving, the Save as dialog box pops up? And then I can't even overwrite the original file because it's marked as Read-Only. .........................

Honestly, so many people run into this exact issue. I actually kept a thread about this on an old forum I used to follow, so

check it out right here

It’s not working because you didn't set up the formula name correctly in the Formulas > Name Manager tab.
So, here is what you do: just highlight the range D3:E10 with your mouse—just like Kyle Johnson2 already suggested—then head over to Formulas > Name Manager, hit NEW, and type in name: cities. In the refers to box, you'll see the range you just selected (though you can always manually expand it later if you need to). Now, just paste Kyle's formula into cell B3 and drag it down. It should run as smooth as a high-end Mercedes.

p.s. Man, it breaks my heart seeing people struggle like this. I guess I have a bit of a saintly streak in me (even if I'm nothing like Kyle Johnson2), though maybe there's a little mischief there too; (MATCH a 😂😂, I totally lost track, and now I see everything clearly))

Come on, let's back up a bit and get real here—we aren't talking about lukewarm water.

Arthur Ramirez20 said:I'm trying to run some sorts in Excel, but I keep getting an error because of merged cells. Is there any way to actually sort if those cells are joined? Or maybe I should just unmerge them first?

The fields you're trying to sort really need to have matching formats.
> single: A, B, C...
> merged: AB, CD, DE...
> merged: ABC, DEF ....
...

p.s. Just remembered you were on the blacklist! 🙂

I totally get where you're coming from, but you won't find that in Google Sheets. Honestly, you might as well have just told a joke instead. 🙂

Trying to work with anything larger than an A3 sheet in Word is just pure chaos—it’s like the software is actively fighting you.
Maybe give PowerPoint a shot if you want to design a poster?

p.s. Just try searching Google (or YouTube) for "how to print poster size document" and see if any of those methods actually work for what you need.

Anthony Kern80 said:Yeah, but I've already finished writing all the actual content. All I need now is to add those little dots and page numbers, so that link doesn't really help me much.

Why did you bother writing everything out manually if the software can just automate the whole thing—including the bullet points—like Kyle Johnson2 explained in the instructions?

Just click References -> Table of Contents; it solves all your problems instantly. Why struggle with it?

Michael Jackson10 said:Alright, I guess it’s my turn to step up and play the expert after handing out so much advice lately! 🤦

So, here’s my question regarding Excel 2010:

Actually, you pretty much answered your own question 🙂, though I have to admit I've never actually needed to do something like that in a real-world scenario.

- It just occurred to me, when you hold down ALT plus ENTER, you can create line breaks within a cell to shift text around—like making the entry sit in the top third of the cell, for instance. But isn't the catch that it messes with things like sums? It only really works if you manually increase the row height, which I doubt would actually satisfy what you're looking for... or would it?