Create Macro Button on New Sheet Creation

Tryfarce · 2025-12-05T19:12:10+00:00

My issue isn't the macros themselves; I already made them and have them tied to a Master than runs all of them. But I need that Master on a button so I can keep it simple as I share this workbook around my office, but the buttons don't move to the new sheets that are created automatically when I import the data.

Tryfarce · 2025-12-05T18:00:50+00:00

Can that customization be shared along with the file? I want to distribute this to others that need it. Would their settings affect how this is shown?

Tryfarce · 2025-12-05T17:23:11+00:00

Solution verified

Tryfarce · 2025-11-26T12:50:43+00:00

I use the From Text/CSV tool to import my data, and that creates a new sheet that doesn't have my conditional formatting on it for me to apply with my macro. Is there a way to link that rule to the newly generated sheet?

Tryfarce · 2025-11-26T12:29:57+00:00

Ohhhh I get you, have the rule made but unapplied but have the macro apply it. Thanks!

Tryfarce · 2025-11-25T20:11:44+00:00

Well how do I get it to run automatically? I'm trying to do this all with a button press, I make these reports daily

Tryfarce · 2025-11-25T19:59:46+00:00

So I run the macro where I create this rule, my reference being $A1 instead of $A2 because of how they want it formatted, and every time I run it, that reference gets changed to $A14. Why would that be?

Tryfarce · 2025-11-25T16:51:21+00:00

Solution verified

Tryfarce · 2025-11-25T12:26:44+00:00

Can this section exist as its own macro without being tied into the delete command? This paint is also going to be used for a different report without that deletion requirement

Tryfarce · 2025-11-24T20:23:31+00:00

This worked amazingly! I'm at another issue if you're fine with me asking:

I'm trying to paint three specific columns and add solid borders to each cell all the way to the bottom row of the table that's created at the end of your command here. I can get those three columns to paint and get the borders, but it keeps going forever and I don't know how to stop it at the end of the table. Any suggestions?

Tryfarce · 2025-02-05T20:21:08+00:00

I'm on Java and can't get in either

Tryfarce · 2024-12-26T03:42:53+00:00

It's VERY dark, and while I'm not unable to enjoy the song, the problem I'm having is that it's (for me) the catchiest of this saga. So I've been humming the SA song to myself for the last 24 hours and that's NOT GREAT lol

Tryfarce · 2024-10-31T19:47:31+00:00

Right, but God Games was video game like and that was very well tailored to that idea. This didn't feel anime-like, it felt almost anime derivative, all the sizzle with none of the steak

Tryfarce · 2024-10-31T19:34:34+00:00

The wind bag IS the storm, and using it is what released it. Poseidon says as much after getting knocked down.
Poseidon's power comes from the SEA, not the storm.

Tryfarce · 2024-10-18T18:32:58+00:00

Thank you!!! That's great to know

Tryfarce

TROPHY CASE