Just the other day I was unhappy about the iOS new feature called Parallax which makes those fancy zoom in and out of the apps and folders. Little research and I found the way to turn it off but you must be running at least iOS 7.0.3 when the option to switch it off was introduced. It’s called “reduce motion” and I strongly recommend you give it a try, especially if you run iOS 7 on iPhone 4S or iPhone 4 which are less powerful devices for such a new and resource hungry software.
If you have ever tried to record a macro only to later discover that you’re getting ‘macro too long’ error message, you should consider to split a big macro project more that 1,400 lines) into several parts. Once you record separate macros (or, alternatively, you can record the whole thing and later cut it manually in code into several macros – requires more than just a very basic skills and so not recommended for novices) you need to make a new macro which will ‘call’ part A, B, C etc. one after another to execute the full project.
In below example you can see visual basic command ‘call’ + [macro name] repeating several times – this runs each macro within the bigger picture. I have also used ‘If’ condition – you can set the criteria in the master macro file (xlsm – macro enable spreadsheet) and then using the drop down menu use your own way to customise your report.
See the example code below.
Sub Big Project()' ' Big Project Macro '' If Range("l16").Value = "Yes" Then Call Project_Presorting End IfIf Range("l12").Value = "Yes" Then Call Project_PartA Call Project _PartB End IfIf Range("l12").Value = "No" Then (this condition excludes option of running macro called Project_PartB) Call Project_PartA End If If Range("l18").Value = "Yes" Then Call Project_Part C End IfEnd Sub
This one’s kind of old but I think some night not be aware of it, so here it goes.
If you “happen to be using” free version of Microsoft Windows 7 and after six months you start getting messages stating that your Windows is not genuine, what do you do to get rid of these notifications?
Some people would go the lengths of getting specific software to do the job, but I have found much easier, quicker way.
Just run your Command Prompt (as administrator, option available when right-clicking the icon) from your Start menu. And then type “slmgr -rearm” and hit enter. Next time you restart the computer it will work like new. What this command does it resets the Windows 7 timer by 120 days. So this means you might need to do this twice a year but I’m sure it’s worth the “effort”.