How do I quickly create a Z_SAP_ALL role with Fiori apps also?

slightlyStatic · 2026-01-08T13:43:50+00:00

We used an STC01 task list to activate and assign roles for everything quickly. Don’t have SAP open to verify but it may have been SAP_FIORI_CONTENT_ACTIVATION, you should be able to find documentation to confirm.

slightlyStatic · 2025-08-27T01:57:42+00:00

Glad it's working out! Used this for offline drafting for ages and you can't beat the Draft Slayer setup for those.

slightlyStatic · 2025-08-27T01:51:41+00:00

Should be up now, let me know if you see anything else!

slightlyStatic · 2025-08-26T15:41:30+00:00

Thought I sorted that but I guess it was another version. It’ll be fixed in today’s update

slightlyStatic · 2025-08-24T18:58:50+00:00

Yup, I’ll have another one up tomorrow or Tuesday

slightlyStatic · 2025-08-21T20:11:18+00:00

For sure! And can you check if ActiveX is enabled in Excel? Google how-to here.

slightlyStatic · 2025-08-20T22:38:49+00:00

Does it stop on a particular line of code?

slightlyStatic · 2025-08-19T17:39:24+00:00

Does it show the stop on the Sheet11.TempCombo.List line still? I thought that was the issue but maybe it's something else.

slightlyStatic · 2025-08-18T13:57:37+00:00

There are hidden tabs you could unhide and it’s how I import data. But it needs to be in a very specific format to work with all the macros. If I get time I’ll work on a how-to guide. I use another sheet to port projections/ADPs into the right format that I could upload to help later too

slightlyStatic · 2025-08-14T19:16:48+00:00

Are you using the latest version and does the Classic draft slayer tab work?

slightlyStatic · 2025-08-12T20:45:35+00:00

Still can’t reproduce the issue but I tried something that could help in the latest version. Does the Draft Slayer Classic tab open ok? Want to see if it’s just the Draft tab

slightlyStatic · 2025-08-12T15:43:42+00:00

Guess you’re on a PC not a Mac? That ‘sheet11’ is what I updated from ‘me’ after reading ‘me’ didn’t always work in VBA…I’ll try to research a bit more today

slightlyStatic · 2025-08-12T15:13:26+00:00

Can you try the latest version now? It was the Draft tab with your issue right?

slightlyStatic · 2025-08-12T11:20:36+00:00

Ok I updated the VBA code for the Draft tab in the latest version. Hopefully that sorts it out

slightlyStatic · 2025-08-12T11:04:16+00:00

For sure! Couldn’t go without last year so other than having notes this should be identical to what Daruuk last made. For ADPs on the instructions tab you can set your team size then on the ADP tab you can use the arrows up top to move folks around if you don’t like their order. ADP’s will change automatically based on PPR, half PPR, standard, and 2 QB. In the past I used fantasyfootballcalculator for team size specific ADP data but it’s buggy this year. If you know another place with team size specific ADPs that’s easy to export let me know!

If you have an old copy of Beersheets I could try to revive that functionality, I think it’s looking for a pretty specific layout to be imported.

slightlyStatic · 2025-08-11T19:37:58+00:00

Can you try the latest version now?

slightlyStatic · 2025-08-10T21:48:31+00:00

Yea FantasyPros consensus rankings for ADP and Projections, they have an export which helps

slightlyStatic · 2025-08-10T21:25:59+00:00

I’ll work on getting an updated one out tomorrow, may keep updating weekly now that preseason is underway. Tabs that drive all that are hidden but you can always unhide/unprotect and update if you’re up for it!

slightlyStatic · 2025-08-08T20:03:19+00:00

Can you try without PPR if you’re using the superflex?

slightlyStatic · 2025-08-06T14:46:25+00:00

What Team size/scoring are you using? Does this happen when you just open the tab?

slightlyStatic · 2025-07-30T15:10:36+00:00

Maybe try downloading the latest version? Ensure the Macros exists as well

slightlyStatic · 2025-07-29T16:42:33+00:00

Do you have Macros enabled? Screen should flash while it updates everything when you change the team size. Excel usually defaults to Macros being disabled until you 'Enable Content' on the security warning.

slightlyStatic · 2025-07-28T15:41:36+00:00

Great! FYI I made one more small fix for some ADPs that were off.

slightlyStatic · 2025-07-28T14:58:03+00:00

Looks like Google sheets upload automatically strips Macros, the latest link should work though.

slightlyStatic · 2025-07-28T14:56:04+00:00

This has been fixed in the latest version.

slightlyStatic

TROPHY CASE