How to make a clear button to clear some selected Cells

[mmsamaddar]

Good afternoon,

Need Help: I have a sheet with too many workings (formula) and I have made it password protected. In this sheet, I have some cell to edit or input some data that will make a result. The editable cell is C14:E44, D4, H14:G44, K5. But rest of the cell is fully protected. Here I need a button for clear those cell by one click in Excel 2010 or select all those cell with the help of hyperlink as Select as Delete with that one click.
Can you help?
Regards,
Madhu

 

[bobhc]

Have you tried to record a macro with the actions you want

 

[Khalid NGO]

Hi,
I tried this as Bob advised:

Sub Macro1()
    Range("D4,K5,C14,E44,G44").Select
    Selection.ClearContents
    Application.Goto [a1]
    End Sub

Make a button or shape > right click > select assign macro > Macro1

Regards,

 

[mmsamaddar]

No, I am very little aged at macro. I need to be clarified about VBA or macro.

 

[mmsamaddar]

Hi,
I tried this as Bob advised:

Sub Macro1()
    Range("D4,K5,C14,E44,G44").Select
    Selection.ClearContents
    Application.Goto [a1]
    End Sub

Make a button or shape > right click > select assign macro > Macro1

Regards,

I have also input a code for another purpose. If I want to add this code to the existing code, what should I do?

 

[bobhc]

Please read this link, it will help you in recording macros, read and try, experiment in a work book, you will see its not as hard as many think.

https://support.office.com/en-nz/ar...3ea70e64937b?ui=en-US&rs=en-NZ&ad=NZ&fromAR=1


.

 

[bobhc]

If you post on multiple forums it is good manners to inform members on all forums that you are doing so.
Members are giving their time for free to help you and do not realise you are get the answer from another forum and you are wasting their time.


.

 

[mmsamaddar]

Thanks both of you as you suggested I tried and finally works like charm.