How do I assign a toolbar button to a custom number format I created?
How do I assign a toolbar button to a custom number format I created?
Record a macro and save it to your personal.xls while applying the format,
would look something similar to
Option Explicit
Sub Macro1()
Selection.NumberFormat = "$#,##0_);[Red]($#,##0)"
End Sub
now edit it a bit and add 2 lines
Option Explicit
Sub Macro1()
Application.DisplayAlerts = False
Selection.NumberFormat = "$#,##0_);[Red]($#,##0)"
Application.DisplayAlerts = False
End Sub
now attach it to a custom button
--
Regards,
Peo Sjoblom
"FuadsCurse" <[email protected]> wrote in message
news:[email protected]...
> How do I assign a toolbar button to a custom number format I created?
Peo
Why is it choking on this line?
Selection.NumberFormat = "_(* #,##0.0_);_(* (#,##0.0);_(* " - "_);_(@_)"
Brett
"Peo Sjoblom" wrote:
> Record a macro and save it to your personal.xls while applying the format,
> would look something similar to
>
> Option Explicit
>
> Sub Macro1()
> Selection.NumberFormat = "$#,##0_);[Red]($#,##0)"
> End Sub
>
> now edit it a bit and add 2 lines
>
> Option Explicit
>
> Sub Macro1()
> Application.DisplayAlerts = False
> Selection.NumberFormat = "$#,##0_);[Red]($#,##0)"
> Application.DisplayAlerts = False
> End Sub
>
> now attach it to a custom button
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "FuadsCurse" <[email protected]> wrote in message
> news:[email protected]...
> > How do I assign a toolbar button to a custom number format I created?
>
>
>
Try this
Selection.NumberFormat = "_(* #,##0.0_);_(* (#,##0.0);_(* "" - ""_);_(@_)"
--
Regards,
Peo Sjoblom
"FuadsCurse" <[email protected]> wrote in message
news:[email protected]...
> Peo
>
> Why is it choking on this line?
>
> Selection.NumberFormat = "_(* #,##0.0_);_(* (#,##0.0);_(* " - "_);_(@_)"
>
> Brett
>
> "Peo Sjoblom" wrote:
>
>> Record a macro and save it to your personal.xls while applying the
>> format,
>> would look something similar to
>>
>> Option Explicit
>>
>> Sub Macro1()
>> Selection.NumberFormat = "$#,##0_);[Red]($#,##0)"
>> End Sub
>>
>> now edit it a bit and add 2 lines
>>
>> Option Explicit
>>
>> Sub Macro1()
>> Application.DisplayAlerts = False
>> Selection.NumberFormat = "$#,##0_);[Red]($#,##0)"
>> Application.DisplayAlerts = False
>> End Sub
>>
>> now attach it to a custom button
>>
>>
>> --
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>>
>> "FuadsCurse" <[email protected]> wrote in message
>> news:[email protected]...
>> > How do I assign a toolbar button to a custom number format I created?
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks