Thread
:
Macro Button
View Single Post
#
4
Posted to microsoft.public.excel.misc
papou[_2_]
external usenet poster
Posts: 112
Macro Button
Gary
Your code works fine on my Excel version (2003 SP3).
There must be some other reason like protected cells or merged cells ?
Or ?
HTH
Cordially
Pascal
"Gary" a écrit dans le message de news:
...
I still get "select method of range class failed" and highlights the
following
Range("E:E,G:G,H:H,I:I,J:J,F24:F26").Select
"papou" wrote:
Hello Gary
If you are running code from a commandbutton from the Controls tool box
then
consider setting the TakeFocusOnClick property to false.
HTH
Cordially
Pascal
"Gary" a écrit dans le message de news:
...
I have written a macro to change the currency format of certain cells on
a
number of different sheets in one workbook. It works when i run it
through
tools/macros/ run, but goes into error when i try and run it from a
click
button, any ideas
Reply With Quote
papou[_2_]
View Public Profile
Find all posts by papou[_2_]