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

 

[steve smallman]

Bob,

the short answer is yes. The place to start your macro is
to record the actions that you wish to perform. To do
this, start the Macro Recorder using Tools/Macro/record
new macro.

Use the menus and keystrokes rather than the mouse, and
once your repetitive tasks are repeated, stop the
recorder.

now comes the fun bit

Goto
Tools/Macro/Visual Basic Editor
Use the project explorer window to find your code, and
read through the code you have recorded.

Don't worry, there will be lines you cannot understand.
Use help, and step through the code (F8) to see what each
line does.

If/When you get stuck, repost to the Programming
newsgroup and you will get some assistance there.

Steve

 

[steve smallman]

Bob,

the short answer is yes. The place to start your macro is
to record the actions that you wish to perform. To do
this, start the Macro Recorder using Tools/Macro/record
new macro.

Use the menus and keystrokes rather than the mouse, and
once your repetitive tasks are repeated, stop the
recorder.

now comes the fun bit

Goto
Tools/Macro/Visual Basic Editor
Use the project explorer window to find your code, and
read through the code you have recorded.

Don't worry, there will be lines you cannot understand.
Use help, and step through the code (F8) to see what each
line does.

If/When you get stuck, repost to the Programming
newsgroup and you will get some assistance there.

Steve