By the way, the code to Zoom the window is
ActiveWindow.Zoom= 120
which means 120%
Regards,
Sam
On Thu, Nov 10, 2011 at 10:54 PM, Sam Mathai Chacko wrote:
> You CAN increase the font size if it is an Activex Control. Form Controls
> like mentioned earlier, don't allow font size increase or decr
You CAN increase the font size if it is an Activex Control. Form Controls
like mentioned earlier, don't allow font size increase or decrease.
Regards,
Sam
On Thu, Nov 10, 2011 at 9:50 PM, Mahreen Ellahi wrote:
> Nop didnt get the desired result, anyways m making a new sheet with 100%
> zoom and
Nop didnt get the desired result, anyways m making a new sheet with 100%
zoom and its working thanks
Mahreen
On Thu, Nov 10, 2011 at 7:49 PM, wrote:
> For example, with Data Validation cells in column D:
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Target.Count > 1 Then E
For example, with Data Validation cells in column D:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column = 4 Then
Target.Columns.ColumnWidth = 20
Else
Columns(4).ColumnWidth = 5
End If
End Sub
To add this code to the worksheet:
Right-cli
Any code?
On Thu, Nov 10, 2011 at 3:55 PM, wrote:
> Well u can use the code mentioned in the link to make it zoom a bit
>
> On , Mahreen Ellahi wrote:
> > Thanks :-(
> >
> >
> >
> > On Thu, Nov 10, 2011 at 3:43 PM, waheedb...@gmail.com> wrote:
> >
> >
> > Hi,
> > Its fixed size you cant cha
Well u can use the code mentioned in the link to make it zoom a bit
On , Mahreen Ellahi wrote:
Thanks :-(
On Thu, Nov 10, 2011 at 3:43 PM, waheedb...@gmail.com> wrote:
Hi,
Its fixed size you cant change it.
Plz refer the below link
http://www.contextures.com/xldataval08.html
O
