Clickable button on worksheet & hiding question

  • Thread starter Thread starter Lee Harris web
  • Start date Start date
L

Lee Harris web

I have a worksheet that uses a random number to lookup values on a set
of cards and formats them so it looks like a physical card on the
screen

At the moment, I just select any cell outside the card region and hit
delete, which forces RAND to recalculate and hence flip a new card.
What I would like to do (in the easiest and quickest way possible) is
to have either a bitmap or a standard button that a user can see as
"Click to draw card" which I think is a bit nicer than the current way

the second thing I'm after is knowing how to hide and lock stuff away
properly. If possible (?) I would like to make the card looks like it
is free floating in excel, ie the cells around it have all
disappeared, maybe even get rid of excels row and column labels too.
On a more general note, how to hide cells and worksheets away so that
people getting this file can't fiddle about with stuff or see the
inner workings (having said that, will that end up causing me problems
if I need to change things?)

thanks in advance
LeeH
 
For your first question, you can easily draw a command
button (view\toolbars\control toolbox), then right-click
and select 'edit text' to put "Click here"; finally,
right-click and select "assign macro" - enter this:
Sub Button1_Click()
Calculate
End Sub
and save. Your new button should force a recalc.

jlr
 
For part of question 2, there is a 'toggle grid' icon. -
I'm not sure which tool bar shows it, but it clears the
grid on the screen. (the row and column indicators remain)

jlr
 
Back
Top