I have a 2 item wishlist of items that could be done with
programming. I use a construction estimate workbook that
can have several estimates for one project in the book and
some of the estimates can be pretty long (9 or 10 printed
pages).

1. Can I create a button that displays the value of a
cell (With a short description). It would be kind of like
the watch box but a lot easier to read and docked onto the
toolbar in the size of a drop-down button.

2. Can a background be added to a sheet so that I can
differentiate sheets when looking at it? All estimate
sheets tend to look the same when you have 6 of them and
it is 15 minutes before the bid. I'd like a sheet name or
something to show up kind of like a watermark in the
background. It would have to move with the scrolling or
be repeated as you go down the sheet.

Brian,

For your second question
Use Format Sheet Background and find a picture or whatever.
This will be duplicated across your worksheet.
Or use cell shading.

For the first
Dim msg as String
msg = MsgBox("This is my value" & Chr(10) & Range("A1").Value, _
vbOKOnly)

Assign the macro to the button.
--
sb
"brian" wrote in message
...
I have a 2 item wishlist of items that could be done with
programming. I use a construction estimate workbook that
can have several estimates for one project in the book and
some of the estimates can be pretty long (9 or 10 printed
pages).

1. Can I create a button that displays the value of a
cell (With a short description). It would be kind of like
the watch box but a lot easier to read and docked onto the
toolbar in the size of a drop-down button.

2. Can a background be added to a sheet so that I can
differentiate sheets when looking at it? All estimate
sheets tend to look the same when you have 6 of them and
it is 15 minutes before the bid. I'd like a sheet name or
something to show up kind of like a watermark in the
background. It would have to move with the scrolling or
be repeated as you go down the sheet.

1. Bring down a TEXT BOXselect itin the formula bar type =c11
2.http://tinyurl.com/krza


"brian" wrote in message
...
I have a 2 item wishlist of items that could be done with
programming. I use a construction estimate workbook that
can have several estimates for one project in the book and
some of the estimates can be pretty long (9 or 10 printed
pages).

1. Can I create a button that displays the value of a
cell (With a short description). It would be kind of like
the watch box but a lot easier to read and docked onto the
toolbar in the size of a drop-down button.

2. Can a background be added to a sheet so that I can
differentiate sheets when looking at it? All estimate
sheets tend to look the same when you have 6 of them and
it is 15 minutes before the bid. I'd like a sheet name or
something to show up kind of like a watermark in the
background. It would have to move with the scrolling or
be repeated as you go down the sheet.