close

Hi
Newbie question, I think

I have some macros in my workbook that are activated by lt;ctrlgt;lt;shiftgt;A,
lt;ctrlgt;lt;shiftgt;B, lt;ctrlgt;lt;shiftgt;C, etc. My prob is that they work on EVERY
sheet, but i'd like them to work only on certain designated sheets. Any
ideas how to go about this?

Merci
Giselle
Giselle, you could check for the sheet name like this,

Sub test()
If ActiveSheet.Name = quot;Sheet2quot; Then
'Your Code here
Else
Exit Sub
End If
End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003

quot;Gisellequot; gt; wrote in message
...
gt; Hi
gt; Newbie question, I think
gt;
gt; I have some macros in my workbook that are activated by lt;ctrlgt;lt;shiftgt;A,
gt; lt;ctrlgt;lt;shiftgt;B, lt;ctrlgt;lt;shiftgt;C, etc. My prob is that they work on EVERY
gt; sheet, but i'd like them to work only on certain designated sheets. Any
gt; ideas how to go about this?
gt;
gt; Merci
gt; Giselle
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()