teleren/devto huggingface dataset:
How to Remove All Macros within Worksheet or Workbook in Excel?
Tags: kutoolsexceltutorial, removeallmacros, kutools
Published: 2020-10-22 12:15:27

---
title: How to Remove All Macros within Worksheet or Workbook in Excel?
published: true
date: 2020-10-22 07:28:27 UTC
tags: KutoolsExcelTutorial,RemoveAllMacros,Kutools
canonical_url: https://geekexcel.com/how-to-remove-all-macros-within-worksheet-or-workbook-in-excel/
---

In this article, we are going to see how to **Remove All Macros within Worksheet or Workbook in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## **Remove All Macros:**

If you want to eliminate all macros within the worksheet, you need to follow the below steps.

- On the **Kutools Tab, select** the **Delete** option, **choose** the **Remove All Macros** option from the drop-down list.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-25.png)<figcaption id="caption-attachment-16121">Kutools Tab</figcaption>

- After clicking the Remove All Macros option, a prompt box will pop-out to tell you that all the macros in the entire workbook have been removed successfully.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Prompt-box-7.png)<figcaption id="caption-attachment-16127">Prompt box</figcaption>

### Removing all Macros can help you to delete the following items:

| Item | Description |
| --- | --- |
| [VBA Macros](https://geekexcel.com/vba-macros/) | It will eliminate all VBA Macros, VBA modules, class modules, code modules for the workbook. |
| User Forms | This will delete all User forms. For example, custom dialog boxes created with VBA. |
| Dialog Sheets | Eliminate the sheets that store custom dialog boxes. |
| XLM Macros Sheets | Delete the sheets that store XLM macros. |

## **Verdict:**

In the above article, you can clearly understand the steps to **Remove All Macros within Worksheet or Workbook in Excel Office 365** using **Kutools. ** Drop your **feedback** in the below comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Toggle All Hidden Sheets to be Visible or Invisible in Excel Office 365!!](https://geekexcel.com/toggle-all-hidden-sheets-to-be-visible-or-invisible-in-excel-office-365/)
- [Fetch Values From Cells for Calculation in Excel Office 365!!](https://geekexcel.com/fetch-values-from-cells-for-calculation-in-excel-office-365/)
My Next.js and Tailwindcss starter template
Tags: nextjs, typescript, template
Published: 2020-10-22 07:27:09

Recently I have been releasing a new starter template build on top of Next.js, Typescript, and Tailwindcss.

It's included:
- Eslint, Prettier, and Stylelint setup
- SEO ready
- and many more

You can visit the demo pages at: https://nextwind.vercel.app

If you feel this is missing please open a new issue or you can also open a pull request, and if you find something new and this helps you can leave a star for me. Thank you.

{% github kaliwa/nextwind %}
How to define instance data in your view - craftkit best practice
Tags: craftkit, javascript, shadowdom, webdev
Published: 2020-10-22 07:26:20

When you make view class that hold instance data, like data from user action, data from server, and so on, you can hold those data anywhere you want. 

But the best practice of managing instance data of Craft.UI.View sub-class is to set them into `this.data`. 

Craft.UI.View and its super-class Craft.Core.Component has many field by default. Those fields are designed to not conflict with user land usage. But sometimes it might be occurred.

To prevent field confliction, you are recommended to set your instance data in `this.data`.

Example:

```javascript 
class HeaderTitle extends Craft.UI.View {
	constructor(options){
		super(options);
		this.data = {
			title : options.title
		};
	}
	template(componentId){
		return `
			<div id="root" class="root">
				<h1>${this.data.title}</h1>
			</div>
		`;
	}
}
``` 

When you make sub-class of HeaderTitlte, it is recommended to define its own `this.data`. 

```javascript 
class SmallHeaderTitle extends HeaderTitle {
	constructor(options){
		super(options);
		this.data = {
			title : options.title
		}
	}
}
``` 

But you can cascade super-class `this.data` if you need.

```javascript 
class DualHeaderTitle extends HeaderTitle {
	constructor(options){
		super(options);
		this.data = Object.assign(
			{
				sub: options.subtitle 
			},
			this.data
		);
	}
	template(componentId){
		return `
			<div id="root" class="root">
				<h1>${this.data.title}</h1>
				<h2>${this.data.sub}</h2>
			</div>
		`;
	}
}
``` 

Further more:

When you would like to apply observer observable pattern like using [Proxy](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Proxy), just you have to watch is change of `this.data`.

🛺 Try CraftKit Playground:
https://github.com/craftkit/craftkit-playground
Are you a backend engineer?
Published: 2020-10-22 07:19:53

##About Us
We are a pack of skilled software engineers hunting for someone to fill in the current vacuum in the team. We are building a suite of software products that will change how the Real Estate Industry functions in India.

If you have the courage to roar at challenges and want to work with other talented engineers! Let’s talk!

##About The Opportunity
You need to be a passionate, results-oriented, innovative Backend Engineer to contribute to the design and implementation of the large-scale application using a microservices architecture.

A successful candidate will have a strong backend development background, exceptional design skills, excellent problem solving, and communication skills. Daily work will involve liaising with other senior developers, product managers, and principals.

Technologies involved include Django, NodeJS, SQL and NoSQL databases, Websockets, AWS. Come join us and solve some of the most challenging technical problems on the planet by growing and supporting the most innovative software ever built for Real Estate!

##Basic Qualifications
- Bachelor’s Degree in Computer Science or a similar degree
Ability to work in a diverse team
- 4+ years’ experience as a software developer
Proficiency in Python Programming Language 
- Experience building software systems that have been successfully delivered to customers.
- Strong Computer Science fundamentals, including networks and communication, object-oriented design, data structures, algorithm design, and complexity analysis.
- Strong problem-solving skills
- Knowledge of professional software engineering and best practices for the full software development life cycle, including designing, coding standards, code reviews, source control management, build processes, testing, and operations.
- Experience working in Django
- Ability to work with git.

##Benefits
- Work with the Best and Brightest Technical Talent
- The stable and well-funded company
- Virtual Happy Hours, Team Building Events, Hackathons
- Salary as per industry standards or more than your current salary whichever is higher

##How To Apply
To apply for the Backend End Engineer position simply follow this link: https://rethinkux.com/job/software-development-engineer-backend/

_Please feel free to leave questions in the comments section._
Are you a Front End Engineer?
Tags: hiring
Published: 2020-10-22 07:08:25

## About Us
We are a pack of skilled software engineers hunting for someone to fill in the current vacuum in the team. We are building a suite of software products that will change how the Real Estate Industry functions in India.

If you have the courage to roar at challenges and want to work with other talented engineers! Let’s talk!

## About The Opportunity
A successful candidate will have a strong front end development background, exceptional design skills, excellent problem solving, and communication skills. Daily work will involve liaising with other senior developers, product managers, and principals.

Technologies involved include REACT, JavaScript, NoSQL databases, AWS, familiar with state management libraries like Redux. Come join us and solve some of the most challenging technical problems on the planet by growing and supporting the most innovative software ever built for Real Estate!


## Your responsibilities will include
- Design and implement supporting frontend for backend services in mostly ReactJS.
- Solve problems that span multiple layers of the application.
- Closely collaborate with the engineering team.
- Automate all the things related to the frontend. Eg: deployment, testing, or maintenance scripts.
- Research web technology trends.
- Write Unit, Integration, and User Acceptance Tests.
- Help the team grow professionally.
- Solve technical problems of moderate scope and complexity.

##Basic Qualifications
- Bachelor’s Degree or above in Computer Science or related field.
- 3+ years’ professional experience in Front End Development.
Strong Computer Science fundamentals, including networks and communication, object-oriented design, data structures, algorithm design, and complexity analysis.
- Strong problem-solving skills.
- Proficiency in JavaScript, CSS, and HTML.
- Knowledge of professional software engineering and best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations.
- Ability to work with git.

##Benefits
- Work with the Best and Brightest Technical Talent
- The stable and well-funded company
- Virtual Happy Hours, Team Building Events, Hackathons
- Compensation as per industry standards or more than your current salary whichever is higher

## How To Apply
To apply for the Front End Engineer position simply follow this link: https://rethinkux.com/job/software-development-engineer-frontend/



_Please feel free to leave questions in the comments section._
Bot 2048 – ExpectIMinIMax & Bitwise
Tags: go, linux, algorithms, python
Published: 2020-10-22 07:05:29

I spent a lot of my time a few years ago playing this game. Certainly one of the most addictive game! Moreover, the learning phase is very short and you quickly enjoy playing. But after many games you realize that it becomes difficult to go further. Therefore, you have to change the strategy you used to achieve it. Above all I tried to resume many reflections in my bot 2048.

[Read more...](https://algomaths.tech/bot-2048-create-an-artificial-player/)

{% github lunatikub/bot2048 no-readme %}
Radical Candor Review
Tags: bookreview, post
Published: 2020-10-23 05:16:30

---
title: Radical Candor Review
published: true
date: 2020-10-22 07:00:00 UTC
tags: bookreview,post
canonical_url: https://horia141.com/radical-candor-review.html
series: "Book Reviews"
---

This is my review of [Radical Candor](https://www.radicalcandor.com/) by Kim Scott. This is a management book as you can surely surmise. The central idea is that one should practice _radical candor_ in a work environment - a style of interacting with others where one both seeks and offers good and constructive and sometimes hard to hear feedback.

While I found the idea worthy, the book itself felt quite the slog. The message itself is OK, and there’s ample storytelling, justification, and instruction around it. But that can only fill so much book. Hence the bigger part of the book deals with general “modern” management approaches. The kind of stuff you can read about in [The Manager’s Path](https://dev.to/horia141/the-managers-path-review-3fc) or [An Elegant Puzzle](https://dev.to/horia141/an-elegant-puzzle-review-475i). It’s also stuff that I am more or less doing as a manager. Hence my earlier characterization as a slog.

The most worthwhile part was the first one consisting of four chapters. These only dealt with radical candor in itself and why one should care, with copious examples and an analysis of the various facets of it - from relationship building to delegation.

The second part focused on implementation. From this only the last chapter I found useful, but mostly because it had a bunch of easy to apply tips and tricks for time management, meeting structuring, etc. Stuff I could steal right away.

Even given all of the above I am not 100% would want to commit to such a thing, and follow the protocols. I do think a large part of this is achieved via simpler things like building a human relationship with your colleagues and reports, and having structured career conversations. The rest can surely help, but the delta might not be sufficient.

Anywho, at least the highlighted chapters are interesting and worth to dig deeper into. And if you’ve never read any other management book this one isn’t a bad start at all.
How to upload image using ckeditor in laravel 8
Tags: laravel
Published: 2020-10-22 06:59:30

we need to store long text, article content, product summary, and different tag content, etc, with the description in our database, we use the CKEditor editors. this editor's use of text stylish is easy to use any content.

I write a very simple example of image uploading with laravel step by step so you can easily use it in your laravel 8. Ckeditor is the most powerful tool for the content editor. so if you have an image upload option also available then it awesome.

**[How to upload image using ckeditor in laravel 8](https://www.phpcodingstuff.com/blog/how-to-upload-image-using-ckeditor-in-laravel-8.html)**

```
<?php
namespace App\Http\Controllers;
use App\Article;
use Illuminate\Http\Request;
use Response;
class ArticleController extends Controller
{
    public function index()
    {
        return view('article-form');
    }
    public function uploadImage(Request $request) {		
	if($request->hasFile('upload')) {
            $originName = $request->file('upload')->getClientOriginalName();
            $fileName = pathinfo($originName, PATHINFO_FILENAME);
            $extension = $request->file('upload')->getClientOriginalExtension();
            $fileName = $fileName.'_'.time().'.'.$extension;
        
            $request->file('upload')->move(public_path('images'), $fileName);
   
            $CKEditorFuncNum = $request->input('CKEditorFuncNum');
            $url = asset('images/'.$fileName); 
            $msg = 'Image uploaded successfully'; 
            $response = "<script>window.parent.CKEDITOR.tools.callFunction($CKEditorFuncNum, '$url', '$msg')</script>";
               
            @header('Content-type: text/html; charset=utf-8'); 
            echo $response;
        }
    }	
}
?>
```
Installing Docker and Docker-Compose on the Jetson Nano 4GB/2GB in 2 simple steps!
Tags: docker, devops, tutorial
Published: 2020-10-22 06:56:41

You know what [Docker](https://www.docker.com/) is. You know what a [Jetson Nano](https://developer.nvidia.com/embedded/jetson-nano-developer-kit) is. Let me make sure they hit it off together. 😎🤝🏽

This is probably one of the quickest and easiest ways to get Docker and Docker Compose running on the Jetson Nano
(Tested with Jetson Nano 4GB Development Kit)

After searching the Inter-Webs for hours and having several things not work for me, I decided something needed to be done about it.

# Steps

How to install Docker and Docker Compose on the Jetson Nano, the right way!

## 1. Download install script

I have already created a very simple shell file which installs the prerequisites needed to run Docker as well as Docker-Compose itself. Simply download it.

```
wget -O install-dc.sh https://gist.githubusercontent.com/CT83/6dbe0d9df3fd3ba4d57fd3a5347e5105/raw/4975eb302be84cf1755378523343004451c7260d/install-dc.sh
```

## 2. Run the script

The script might need you to prompt "yes" by pressing "Y" a couple of times, do play along with it.

```
sudo sh ./install-dc.sh
```

## 3. Test Docker installation

```
docker run hello-world
```

## Boom! 🔥 It's done!

> Important Notice about Docker on the Jetson Nano
>
> Jetson Nanos use the ARM architecture, and as a result, won't be compatible with all containers out of the box. Images will need to be built from an ARM base image. But, most of these images can easily be found on [Docker Hub](https://hub.docker.com/)

# Appendix

Some things you might find interesting. 

## Shell Script

I would encourage you to take a look at the [install-dc.sh](https://gist.github.com/CT83/6dbe0d9df3fd3ba4d57fd3a5347e5105) script.

```bash
#!/bin/bash
sudo apt-get update -y
sudo apt-get upgrade -y
sudo apt-get install curl python3-pip libffi-dev python-openssl libssl-dev zlib1g-dev gcc g++ make -y
curl -sSL https://get.docker.com/ | sh
sudo pip3 install docker-compose
sudo docker-compose --version
```
Add WordPress user using FTP
Tags: wordpress, ftp, php, admin
Published: 2020-10-22 06:40:42

Recently, one of our clients sent us a list of WordPress website changes with FTP detail but they don’t have a WordPress admin login details.

At that time below code helps us to add a WordPress administrator user. Just add this code on function.php of the active theme.

{% gist https://gist.github.com/YuvrajKhavad/a7c56d094d96b4e642e65464c69c418f %}

Just delete this code after login successfully.

Happy Coding !! Feel free to ask us any questions if have.
Understanding Docker: part 10 – Clean & Purge
Tags: docker, devops, beginners, cloud
Published: 2020-10-22 06:26:04

---
title: Understanding Docker: part 10 – Clean & Purge
published: true
description: Serie of sketchnotes about Docker. Explaining in a visual way Docker principles.
tags: Docker, DevOps, beginners, Cloud
series: Understanding Docker in sketchnotes
cover_image: https://dev-to-uploads.s3.amazonaws.com/i/8yp52juumfb7azsr0sjf.jpg
---

Understanding Docker can be difficult or time-consuming. In order to spread knowledge about Cloud technologies I started to create sketchnotes about Docker. I think it could be a good way, more visual, to explain Docker (and other technologies like Kubernetes and Istio).

We continue the series of Docker sketchnotes with a focus about how to clean and purge Docker data.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/8yp52juumfb7azsr0sjf.jpg)

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/v3kz8m3t9x49hcqeh1pj.jpg)

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/7eyphb12972c3almegmo.jpg)

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/zfvip15xwncx3x4ak6k7.jpg)

If you are interested, I published all the sketchnotes on Docker (and new ones!) to make a "book" of 93 pages: ["Understanding Docker in a visual way"](https://gumroad.com/aurelievache#YTLzM).

As usual, if you like theses sketchnotes, you can follow me, and tell me what do you think. I will publish others sketchs shortly :-).
Think! About Your Work
Tags: programming, pragmaticprogrammer, pragprog
Published: 2020-10-22 06:19:38

---
title: Think! About Your Work
published: true
description: Turn off the autopilot and take control. Constantly critique and appraise your work.
tags: programming, pragmaticprogrammer, pragprog
cover_image: https://yordi.me/uploads/1631px-IBMThink.jpg
---


> Turn off the autopilot and take control. Constantly critique and appraise your work.

Former head of IBM [Thomas J. Watson](https://en.wikipedia.org/wiki/Thomas_J._Watson) was frustrated. He was expecting ideas from his sales managers on how to improve the business, but none of them could deliver. Annoyed by this lack of ingenuity, he took the word and said: 

> "The trouble with every one of us is that we don’t *think* enough. Knowledge is the result of thought, and thought is the keynote of success in this business or any business. We don't get paid for working with our feet - we get paid for working with our heads".

There and then, he decided on the company's slogan, **THINK!**, which is still linked to the company. *Think* as the basis for what turned out to be a very successful business. You can read more about [the origin of IBM's THINK!](https://www.ibm.com/ibm/history/ibm100/us/en/icons/think_culture/) on their website.

It's important to think about what you're doing, while you're doing it. And, also before you're doing it. A few years ago, I wrote an article about how [taking the time to plan will save you time in the end](https://medium.com/@yordiverkroost/taking-time-to-plan-will-save-you-time-in-the-end-537909c679a). The moral of that story is that it pays off to think about what you want to do, before you do it. It's unnecessary to plan out all details and every edge case upfront. Just a small plan is enough to eliminate obvious dead-end paths.

Taking time upfront requires a time investment. From the viewpoint of a software developer, it's the difference between immediately starting to code and having a kick-off meeting with your team. In other words, it's the difference between short-term, temporary success and long-term, continuous improvement. It's quick money versus a stable, healthy business. And in the end, it's up to you which road you want to travel.

---

This post is part of a series about the [Pragmatic Programmer](https://yordi.me/garden/pragmatic-programmer/).
Care About Your Craft
Tags: programming, pragmaticprogrammer, pragprog
Published: 2020-10-22 06:17:51

---
title: Care About Your Craft
published: true
description: Why spend your life developing software unless you care about doing it well?
tags: programming, pragmaticprogrammer, pragprog
//cover_image: https://direct_url_to_image.jpg
---

> Why spend your life developing software unless you care about doing it well?

This quote was taken from a programming book, but it's larger than that. I dare say "caring about your craft" is essential anywhere. Why would you keep doing what you do instead of the thing you actually want to do?

The part about "doing it well" is a logical result of caring about your craft. When you do something you like, you'll do it well. Find something that gets you out of bed every morning, and the rest will follow suit.

If you don't believe me, believe Steve:

> "You’ve got to find what you love. And that is as true for your work as it is for your lovers. Your work is going to fill a large part of your life, and the only way to be truly satisfied is to do what you believe is great work. **And the only way to do great work is to love what you do. If you haven’t found it yet, keep looking.** Don’t settle. As with all matters of the heart, you’ll know when you find it. And, like any great relationship, it just gets better and better as the years roll on. So keep looking until you find it. Don’t settle."
> *[Steve Job's Commencement address](https://youtu.be/UF8uR6Z6KLc), Stanford, 2005*

Building software well serves multiple purposes. At first, it stands the test of time, because it is expandable. Second, it is easy to read, both for others and your future self. And third, it's just awesome to do. What gives more adrenaline than software that was built in a clever yet simple way? Nothing much, really.

---

This post is part of a series about the [Pragmatic Programmer](https://yordi.me/garden/pragmatic-programmer/).