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;
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;
文章標籤
全站熱搜
