Buttons?

[Bob]

I am trying to insert some macros in an attempt to automated some repetitive
processes.

I am a bit lost in certain areas.

1. My sheet has at the very end, after many blank rows, two 3D type buttons.
One of these says "remove tools" and the other says "restore tools" ?

One of the things I have to do is locate these buttons, click restore tools,
then I go to tools, unprotect sheet, enter my updates, protect data, then
close and save .

Can this be automated to save clicking the buttons and going through the
aggro of unprotect etc ?

Any advice greatly appreciated

Bob
London.UK

 

[Jonathan Rynd]

1. My sheet has at the very end, after many blank rows, two 3D type
buttons. One of these says "remove tools" and the other says "restore
tools" ?

What do these buttons do? What's the point of having them? Did you create
them or did someone else?

Why does the sheet need to be protected?