Customized Buttons/Toolbars?

[Navy]

Here's the situation. We're attempting to automate our Engineering log
and have almost everything good-to-go. The idea is to make the logs a
sailor proof as possible (yes it's true, we can screw almost anythin
up.

Anyway, on to the problem. In the workbook developed I have the actua
"log" worksheet and then a "standard entries" worksheet. I would lik
to have a customized toolbar at the top that would allow someone t
click on it and the Gas Turbine section of the "standard entries
worksheet pops up allowing them to select the particular entry to b
entered into the "log" worksheet. The "standard entries" worksheet ha
about 8 different sections with anywhere from 5 to 20 entries in eac
section. This is probably easy stuff for most of you but I'm a newbi
to excel and I've been beating my head against the bulkhead and book
for the last two weeks.

Since the layout is uniquely Navy, I may not have been overly clear i
what I'm trying to do. If there's any confusion with what I'v
written, please drop me a line and I'll do whatever I can to bette
state what I'm actually trying to do.

Thank you in advance for any and all assistance. :

 

[BrianB]

<we can screw almost anything up>
how about my kitchen cupboards ? (grin). Seriously ....

Not too clear about what stage you are at. You are obviously requirin
some macros, but I am not clear if you have these already or just nee
to attach toolbar buttons. Here is the full routine :-

1. Use Tools/Macros to record the actions you wish to automate.
2. Change the code produced if necessary.
3. Use Tools/Customize/Toolbars/
New to add a blank toolbar,
Commands to add buttons by dragging .
Right click a button - Assign Macro.

Come back with a new messages for more specific problems

 

[Navy]

So far, I have the spreadsheet built and I've figured out how to creat
the toolbar and buttons. I've also figured out how to use dropdow
menus and checkboxes. So those are where they need to be. It's th
macros that have me stumped. I've read a bit but everytime I try ou
what I've read I get an error. There's something I'm just not gettin
with the macros. At one point it was just copying the entire sectio
into the log instead of giving the option to select a portion (usuall
just one or two rows from the "standard entries" worksheet.)

The whole recording process is a bit strange as well. I've looke
online and borrowed a few macros here & there to try them out but non
have worked. A few have even created errors that scared the hell ou
of me! Thank god for the 'undo' function!

I think I may have bitten off a bit more than I can handle since I'v
never written a macro before in my life. I'm just plugging away and
finally broke down to ask for help.

Again, thanks in advance for any and all assistance. And thank yo
very much for the propmt reply. I wish the government worked tha
fast!

Cheers

 

[BrianB]

So take it a bit at a time.
I suggest you start by posting a new message (most of us do not rea
messages already with answers). Keep it simple with one problem pe
message (one person may not know all the answers - especially m
<grin>).

Copy/paste your code. (Ctrl+C/Ctrl+V)
Say what you want to happen.
Say what happens instead

 

[Bob Phillips]

Navy,

Post an example of a 'scary' macro.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)