Wednesday, August 9, 2023

Cannot run the macro [*]. The macro may not be available in this workbook + custom button in Excel that goes to previous sheet

"Cannot run the macro [filename.xlsm'!macroname']. The macro may not be available in this workbook or all macros may be disabled." 


How to solve this macro problem in Microsoft Excel? I created a shape so it would function as a button that goes back to the previous sheet or the next sheet. But my macro didn't run. That guy just walks off on it's own. Maybe going to the next town, getting some milk. Who knows? 

Sorry I'm so sorry. I was creating my own inventory Excel but encounter this hurdle. So here's how I solved it? 

1. Ctrl+click on that button, (so I could select that button) 

2. right click (I want to get second opinion) 

3. look for 'Assign macro...', click on it. 

4. Next, assign newly made Macro to that button. Basically I just override that error. Good bye error. See you never! 


I forgot step 0. 

0. Record a brand new Macros from View > Macros > Record Macro... 

0a. Give your 'Macro name:', but without spaces. Maybe use underscore if you need to. Give description like 'This macro goes hard'. No no no. Write the description as 'This macro go to previous sheet using Ctrl + Page Up' or something like that. 

0b. Click 'OK', 

0c. If it says 'Macro with name 'blablablah' already exists. Replace existing macro? > YES please! 

0d. Actually when you start pressing that OK, it will start to record. So, after that OK, just go on press Ctrl + Page Up together. 

0e. Click 'Macros' > Stop Recording. That should be it. 

0f. Go back to your button just now, click on it. It should bring you back to previous sheet. That error 'Cannot run the macro...' should be gone by now. 


The last step is to save it into your computer. Save it as a file with extension of .xlsm. 

File > Save As > This PC > Desktop > go to the Save as type > choose Excel Macro-Enabled Workbook (*/xlsm) > click Save. And you're done. 

Close all your Excels and everything. Try open that Excel with macro and try clicking on your button again. It should work. If it didn't, Sorry, I don't know how to solve that. Magically it works when I'm doing it here. 


Tips: 

: For button going to next sheet, record it: Ctrl + Page Down. Yeah, that Ctrl key in your keyboard. Press it together with Page Down keyboard. 

: Let's say you want to remove all macros... Oh no, I actually save a back up before saving it as xlsm file. In case I want a macro free Excel. 

Another option is delete that macro-ed button and create a new one. View your macros and delete all unused macros. 

: In order for macro to work, when opening that xlsm Excel, you need to 'Enable content'. It appears below the ribbon. If you didn't enable it, that Excel becomes read only file. Hahahaha. 


I guess that's it? This method worked with Microsoft Office LTSC Professional Plus 2021. Eh, I thought it was Microsoft 365? I download Excel app from Explore all your Apps in Microsoft 365... 

Last but not least, 

I've uploaded that xlsm file in OneDrive, and try clicking on my macro-ed button, but it didn't work. Button with hyperlink to Index sheet is working. But macro-ed button do nothing... 

Thank you to Youtube: Two Quick Shortcuts to Switch Sheets in Excel #Shorts for the Excel sheet keyboard shortcut. 



Bye.

Thursday, December 6, 2018

How to Delete Images & Photos from Blogger

.: Have you uploaded images or photos into Blogger and...
  • you think the picture is low in quality and you want to delete it? 
  • that picture is not for the internet to consume? 
  • I immediately regret my wrong clicking? 

Cry no more!

Go to [ https://get.google.com/albumarchive/ ], there may be multiple items there > look for 'Photos from Blogger' > Pick the blog you're working on > Don't worry it is never sorted alphabetically > search for that unwanted picture > delete it and boom!

That's it. Bookmark the link =
https://get.google.com/albumarchive/

 It will save your long day. Keep Calm and be Happy~

Yep, it is dark in here. [Google AlbumArchive]

Ooigi.blog: "Thank you very very much TechJourney!"

:.

Wednesday, October 31, 2018

OnePlus 6T : Cute Lovable Traitor Smartphone

.: I took my time watching some videos. I rate the newest model is medium best because I love the led thingy and the godfather Headphone Jack.

Of course I don't have the actual phone yet. But watching these videos, I assure you I won't trade my Samsung A6+ yet. It's better to wait for OnePlus to merge both OnePlus 6 and OnePlus 6T together in one model.

OnePlus X6T??? (you traitor!)

Wait, I don't randomly say OnePlus is our Android traitor, but I heard it from Angie Zampona say it.

I already have arrange some review videos and let's start with something soft and later we go to the killer review zone. You'll get what I meant later.

OnePlus 6T from Youtube.


First video: OnePlus 6T promo video~


The coveted proper fingerprint hint~ Yesssss!!
That is Sic.

The second video : Review by Dave Lee - the heat sensor guy!


I prefer him to scan the heat emitted by this phone just like he scan the notorious overheating Macbook. But, oh well. Points taken from this video :
  • Teardrop shape notch is the ooooooooomphh bon appetite~ 
  • Fingerprint sensor under the screen is cool, but slower than the usual fingerprint sensor found at the back of OnePlus 6.
  • if your finger is wet, say goodbye to that sensor. Use your face unlock instead. 
  • This badboy traitor is thicc. 
  • Sadly, NO headphone jack. What. The. Jack??! 
  • Warning, eight legged sighted. 

My third video : Ma man MKBHD review.


My second favorite daily driver guy after Lewis Hilsenteger. He gives out good points too, which is
  • Yep. Teardrop notch is the new black. A curvy one *wink*
  • fingerprint sensor Vivo < OnePlus 6T fingerprint sensor < TouchId or physical fingerprint sensor, the official meme review rating.
  • The cons of this under the screen fingerprint sensor is how they execute it. OnePlus 6T will turn their screen brightness to the fullest in order to scan your fingerprint. During the day it didn't get noticed much, but during the night it certainly gives you some discomfort. 
  • Battery champion. 
  • "No headphone jack because of the larger battery and the fingerprint reader under the screen eats up so much space." - OnePlus 6T 2018. 
  • Hi there. It's General DBrand! 
  • Verizon and T-mobile friendly (soon). 
  • Peace! 

Say Hi to the fourth video : Canadian LinusHomeTips in house coat.


Gotta say his marble table is delicious~
  • Little animation = futuristic. Cool. I approve.
  • The reason why under the screen fingerprint sensor is the best move compared to traditional-hiding-at-the-back-sensor is: there is no need to waste your energy lifting your smartphone that resting on the table to scan your finger, because you can just tap on it directly. Easy tap easy life, right? (compares with Apple phone). I approve. 
  • The least obtrusive notch design award : because it contains all-in-one package, namely the front camera, light+color temperature+distance sensor in one cute place. (compares mechanical camera next). :-P 
  • Drop test coming, like a boss. (Yeah old meme). 
  • Condom type case. Yes Canadian Linus can say that. I approve again. 
  • USB-C to 3.5mm audio dongle \old man appears/ 
  • 3 finger screenshot, draw O to launch camera, draw M to open Maps, etc etc. 
  • 19.5:9 aspect ratio. Whoaaaa... 

And here comes the best video (cause I visit their website to compare new phone specs to my current phone every so often) : GSMArena the sharpest eye~


I know it's boring to hear the same 6T specs again and again, but can I point out some info not found in other video review?
  • I can't stop watching the LegendLegend Hat. 
  • Oppo and Vivo are great couple. Their kid 6T is even greater.
  • This kid is not lit, because LED light is missing. *bummer* 
  • I didn't mind stiff mute button because if it too smooth it defeats the true purpose. If it slides easily silent phone will ring so sudden in my meeting and it will spook everybody. Not ideal there, not that ideal. 
  • Her finger failed the sensor. Is it wet? 
  • I heard UD fingerprint reader. UD stands for Under Display. I gsmarena-ed it for you. 
  • Super color accurate. Wow~ 
  • OnePlus is hypocrite. They mock Apple removing the headphone jack and now they joined the movement. Even after asking users what they want and still they go for jackless phone. What the jack! Traitor! 
  • Gaming mode mentioned. 
  • Here navigation option is cleverly implemented. 
  • Different battery mAh. 
  • The twin camera built is... what? Whyyyy??? 
  • I love new smartphone review that comes together with their actual camera and video review/comparison. 
  • Google Pixel 3 Helicopter pad of a notch. Savage! 

Andddddd, the very best is served last.


I would like to remind you, if you cannot stand phone abuse video, please exclude this. I just wanna share it because it completes the review very well.
  • Sarcasm is everywhere. I approve again. 
  • S reflection is a new kind of review. Different eyes sees and catches different aspect. 
  • Experiments have been done and green light is your best fingerprint friend. 
  • Define indiscernible. He's comparing how invisible the fingerprint sensor placed under this screen compared to other smartphones. How genius! 
  • Please follow his do and don'ts. I've learned the hard way mixing keys and phone screens accidentally.
  • Unboxing videos comes with this subtle satisfying plastic peel audio, but this video screams pain into your deepest soul with the scratch test. Told ya this video is abusive. It pains more when listened with our headphone....
  • Oh, I mentioned already, 6T is the new black. Hahahahaha. It comes from this video~ 
  • This phone is tough. Build 6T tough. (Ford slogan inspiration). 
  • You can flex your OnePlus 6T while flexing the phone itself. Oh no! Call the mobile police. We got an abuser here! 

If you happened to have Samsung smartphone like me but uses OnePlus wallpaper, here is the link to the wallpaper creator himself : Hampus Olsson.

And in some point while watching all these videos, I've been thinking on can I tumblr-ed or Deviantart-ed the 'Never Settle' font for other project? Well, there is no information about the font itself, but I found something kinda related, if you know what I mean... OnePlus Slate font. Please oh please read the disclaimer and understand it. Go Google Translate if you need to. I do not want to be associated with any wrongdoings.


Ooigi.blog: "USD 6++ converted to MYR is likely RM 2,400. Oh myyyyy... Good bye OnePlus 6T. I pray that you will be cheaper soon. Especially your newest model which combines 6 and 6T specs..."
:.

Wednesday, July 25, 2018

Scrub did it again! More of DotA The International TI8 Compendium Predictions~

.: The scrub, aka SavageSkillet : The guys who excels at TI7 compendium predictions last year in reddit have already helped me predicts Hero and Tournament winner, and now he's back with the Team and Players predictions.

And here it goes,
2018 DotA2 TI8 Compendium Team Predictions

and the last prediction,

2018 DotA2 TI8 Compendium Player Predictions

Wait a minute. My personal favorite to win this game is Team Liquid, but LGD seems to be the best predictions. With 22 days to go, let me gather more insights and news about The Liquid ability. Maybe something will happen as we getting near to the biggest day in DotA?

For more scrub detailed data explanation, go visit his awesome predictions explanation in - Esportsheaven : TI8 Compendium Predictions Guide, by a scrub (Part Two).

Disclaimer: I am not affiliated with good boi scrub SavageSkillet but I do earned Adsense earnings if this post is eligible for it.


Ooigi.blog: "Can't wait for the final third treasure to drop. But this year DotA has been a bad boi because the greediness is so obvious. I do hope we will never achieve last year's prize pool of $24.78 million. So TI9 DotA won't be greedy again. "
:.

Friday, June 3, 2016

Pokemon Sun & Pokemon Moon & Manaphy

.: It's been like three years ago after I left Pokemon Y rested in it's own plastic cover. I've stopped playing until the part I get Y, beating Elite Four and capturing Zygarde. Then it's just Monster Hunter all the way.

I used to be a Pokemon fan before (and that time I've played using emulator), but after having my own Nintendo 3DS and original copy of Pokemon Y, finally becoming the Pokemon Champion and then I've lost my motivation to continue playing it. One of the causes is I'm grinding my Monster Hunter weapon and armor.

With one unit of 3DS, you need to alternate between these two games. And for me to continue grinding all my pokemon until level 100 seems so boring because the highest level in Kalos is around 55 to 58 if I'm not mistaken? I used to grind two pokemon until they are 20 levels more in any wild pokemon in an area. When my Fennekin grows level 80, to beat like tons of level 58 pokemon seems ridiculous. Beating Elite Four over and over again also seems to weaken my grinding motivation.

If only The Pokemon Company makes the game to actually level up their wild pokemon in like one special hidden area it would be good. Say, in the new Pokemon Sun and Pokemon Moon there exist an island that cover all basic elements (fire water grass) where I can grind my pokemon. And the wild pokemon there will level up like 10 levels under my most powerful pokemon.

For example, If I got my Litten at level 80 so wild pokemon in that special area will have level 70. When I level up Litten at level 81, so wild pokemon will level up to 71. And so on. This, will make grinding up to 100 will be easier. Heehee.

(In emulator, you don't get to feel the level 100 pokemon because the cheat was too easy. Unlimited rare candy and walking speed over 9000 passing through invisible walls between rooms or big rocks makes level 100 too boring).

All of this rants is made because I never use the O-power. Damn. Why I didn't realize it before? You can grind and make money at the same time fighting inside the restaurant! (T, T )

But grinding in the wild can increase your chances of finding more shiny pokemon...

Enough of this, lemme share two Pokemon videos with you:

Remember guys, November 18, this year!~~


And 2016 is the year of free mythical Pokemon. Every month you can get mythical Pokemon either from the download from internet in your 3DS or by getting code from their website. I already got my shiny Yveltal and shiny Xernias and Manaphy, and too bad I missed the Zygarde gift...

And last but not least, this is a special unofficial noob render of the original casts of Pekomon Sun and Pokemon Moon. Enjoy~

It seems Solrock and Lunatone lacks the legendary/mythical appeal...

Nope, I don't get paid doing this. It's just a noob render and I mean no harm. Please Pokemon, gimme a shiny Mew... (T, T )


Ooigi.blog : "Can't wait to test the Pokemon Go~~"
:.

Monday, September 14, 2015

Pekomon Just Go-t Real?!

.: Things that might be started from Google April Fool prank now just getting real.

This is Gotta Catch 'em All prank in March 2014:-




And then comes Team Rocket. Naaaaaaaaahhhh~~




Sorry, it's coming in 2016 guys...
If you think that you can't wait for this app to appear in App Store or in Google Play, I think you might be interested with this one = [ Pokemon PewDiePie Edition ]...

It's so literally sh***y and it appears in Pewd's video :-


Hey, watch it from 6:49! lol

That's all folks. Ehhh?


Ooigi.blog : "I played Pokemon Blue in emulator when I was a kid because I can't afford GameBoy at that time. I even played it in my friend's computer. Hahaha. Now I got my own 3DS. ;-P "

:.

Saturday, January 19, 2013

Why Java is being targeted?

.: With all the news spreading the superior weakness of Java, let's start why they target the Java first.

A whooping 3 billion devices? Status: Installing insecurities...
While desktop wallpaper is not related, one of my friends just started learning how to create Android games with Java... Thinking about how to make extra money while doing the rat race from 8 to 5 Mon to Friday, I actually want to join the game wagon until this Java news appear... (Lazy excuse detected)

So, just a short post about Java. I've been uninstalling and re-installing Java so I can capture this installing screenshot. So did you uninstall your Java too? Why?

Reading materials:


Ooigi.blog : "So, what is the next global language for all 3 billion devices then?"
:-?
:.