Posted to microsoft.public.excel.programming
|
|
Modify Auto_Open Sub?
Once again, thanks Tom. Have done as you say. Will try
it out. Phil
-----Original Message-----
Have the user enter 75%
it will be stored as 0.75 and displayed as 75%
or
If you preformat the range as %, then the user can just
enter 75 and it will
be interpreted correctly.
Regards,
Tom Ogilvy
"Phil Hageman" wrote in message
...
Bob, I entered the code and tried it out on a users
machine. The user still has to enter a decimal, but
what
shows on screen in the cell is the percentage. Is this
the correct outcome for the added code? If so, okay -
I'll have to educate users.
Phil
-----Original Message-----
Phil,
simply done
Sub Auto_Open()
'This code puts the cursor in cell A1 in all
worksheets,
'and opens the workbook on the "Scorecard" worksheet.
'It also operates when worksheets are hidden.
Application.ScreenUpdating = False
For Each ws In Worksheets
If ws.Visible = xlSheetVisible Then
ws.Select
Application.GoTo ws.Range("A1"), True
ActiveWindow.DisplayGridlines = False
End If
Next
Worksheets("Scorecard").Select
Application.AutoPercentEntry = True
Application.ScreenUpdating = True
End Sub
--
HTH
-------
Bob Phillips
... looking out across Poole Harbour to the
Purbecks
"Phil Hageman" wrote in message
...
Stephen, Thanks for the quick reply. Could we
modify
the
following Auto_Open Sub to automatically make auto
percent
entry setting?
Sub Auto_Open()
'This code puts the cursor in cell A1 in all
worksheets,
'and opens the workbook on the "Scorecard" worksheet.
'It also operates when worksheets are hidden.
Application.ScreenUpdating = False
For Each ws In Worksheets
If ws.Visible = xlSheetVisible Then
ws.Select
Application.GoTo ws.Range("A1"), True
ActiveWindow.DisplayGridlines = False
End If
Next
Worksheets("Scorecard").Select
Application.ScreenUpdating = True
End Sub
-----Original Message-----
Hi Phil,
In Excel 2000, I have created a worksheet for use
on
a
network. Certain cells (formatted percentage)
have
data
values that create an area chart. On my screen, I
enter "75" in the source cell: "75%" shows on
screen,
and
the chart plots a value at 75% (scale maximum is
100%).
However, other users have to enter ".75" to make
things
work right.
Is there a way to have users enter a whole number,
vs a
decimal?
Tools Options Edit Enable automatic percent
entry
Regards
Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk
.
.
.
|