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;

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

software

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