A pop up should be seen after enabling the macro

A pop up should be seen after enabling the macro

Dear here is your solution:

I suggest you to do the following steps.

• First you need to complete your data into the cells and then by selecting the boxes clear data out of the boxes. 

  The key action needs to be performed for doing this action is called as macro. The macro starts with a combination of keystrokes combination command but another way of doing this is to add an macro button on the toolbar to make it convenient. 

• For adding this button you should launch Excel and go to the view menu then select toolbars and scroll downs to the Command tab.
• Second step in this will be to go in the categories option and select forms tab the choice is yours as where to place the button as suitable for you.
• Now you can use check box or open button option for recording into your macro it will just serve like an recording device for you.

Now you can be able to create an Excel sheet in which the macro will be enabled and then you can use colored boxes for the data but make a button color significant and prominent from others that will be used for recording of the macro.

When you move your cursor backwards it will be changed to a cross hair decide the location where you want to place the button and then simply click and drag the button to adjust the size of your desired button the assign macro window will pop up on the window then you can name it as your liking and then use pull down menu option.

Now you can record the macro and also you will have the option to link this macro with all of your worksheets or just the current one.

Try this. If still the problem continues than tell me about this so that I'll be able to actually identify your specific problem.